Range doesnt exists

Help
, ,
1

“=IF(OR(N2=0,H2=0),”“,(NUMBERVALUE(N2)/NUMBERVALUE(H2))*100)”
Using above formula getting error “Range doesnt exists”

2

Hi
close the excel file before running the process and try once and also check once with the formula as well

Cheers @babita

3

What is the original formula?
is it like this?
“=IF(OR(N2=0,H2=0),(NUMBERVALUE(N2)/NUMBERVALUE(H2))*100)"

4

same formula

5

in this y you have use double quotes in between formula
“=IF(OR(N2=0,H2=0),”",(NUMBERVALUE(N2)/NUMBERVALUE(H2))*100)"

use below
“=IF(OR(N2=0,H2=0),(NUMBERVALUE(N2)/NUMBERVALUE(H2))*100)"

1 Like
6

It is working.
Thanks

7

Great !!!

Happy Automation :blush: