Conditional IF function help ??
 

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(N6290,IF(ISERR(N629/L629),"",(N629/L629)))

Thank you ;)

Conditional IF function help ??
 

Try it like this:

=IF(N6290,IF(ISERR(N629/L629),"",N629/L629),"")

Hope this helps.

Pete

On Aug 3, 4:20*pm, H wrote:
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(N6290,IF(ISERR(N629/L629),"",(N629/L629)))

Thank you ;)

Conditional IF function help ??
 

Thank you - works perfectly ;)

"Pete_UK" wrote:

Try it like this:

=IF(N6290,IF(ISERR(N629/L629),"",N629/L629),"")

Hope this helps.

Pete

On Aug 3, 4:20 pm, H wrote:
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(N6290,IF(ISERR(N629/L629),"",(N629/L629)))

Thank you ;)

Conditional IF function help ??
 

You're welcome - thanks for feeding back.

Pete

On Aug 3, 4:39*pm, H wrote:
Thank you - works perfectly ;)



"Pete_UK" wrote:
Try it like this:

=IF(N6290,IF(ISERR(N629/L629),"",N629/L629),"")

Hope this helps.

Pete

On Aug 3, 4:20 pm, H wrote:
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(N6290,IF(ISERR(N629/L629),"",(N629/L629)))

Thank you ;)- Hide quoted text -

- Show quoted text -