Conditional IF function help ??

[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

 

[Pete_UK]

Try it like this:

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

Hope this helps.

Pete

 

[H]

Thank you - works perfectly

Try it like this:

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

Hope this helps.

Pete

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

Thank you - works perfectly





- Show quoted text -