Range doesnt exists

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

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

Cheers @babita

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

same formula

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

It is working.
Thanks

Great !!!

Happy Automation :blush: