Conditional IF function help ??

  • Thread starter Thread starter H
  • Start date Start date
H

H

Hi - I am hoping someone can help me with my If statement. I need it to do
divide Column N by Column L if Column >0

Here's what I tried but it's not working
=IF(N629>0,IF(ISERR(N629/L629),"",(N629/L629)))

Thank you ;)
 
Try it like this:

=IF(N629>0,IF(ISERR(N629/L629),"",N629/L629),"")

Hope this helps.

Pete
 
Back
Top