“=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