Nested If not returning correct values

[murkaboris]

Hello:

I have the following formula:
=IF((T18/G18<=0),"NA",IF(ISERROR(T18/G18),"NA",T18/G18))

It returns the correct values outside of the "ISERROR" section -- so when
there is a division by "0" it gives you the standard "#DIV/0!" which I want
to be replaced by "NA".

Can you please review the formula and tell me what might be wrong that it
still keeps it as "#DIV/0!"?

Thank you.
Monika

 

[JoeU2004]

Think of the arguments of an IF() function as being evaluated from left to
right. So doesn't it make sense that you need test the error condition
before testing a condition that might cause the error condition?

=if(iserror(T18/G18),"NA",if(T18/G18<=0,"NA",T18/G18))

But if #DIV/0 is the only error you are worried about, you could write:

=if(G18=0,"NA",if(T18/G18<=0,"NA",T18/G18))


----- original message -----

 

[murkaboris]

Hi Joe:

I've tried to reverse it and it comes back with an error now highlighting
the "0" in the second portion of the formula after the "<="....any ideas?

Thanks
Monika

 

[JoeU2004]

I've tried to reverse it and it comes back with an error now highlighting
the "0" in the second portion of the formula after the "<="....any ideas?

None, since you did not copy-and-paste here exactly what you entered for the
formula.

I believe you are talking about a syntax error -- a typo. If you
copy-and-paste either of the formulas I provided, I believe you will have no
problem. I don't.


----- original message -----

 

[murkaboris]

Hi Joe:

You were right, not sure what it was with the "0" but when I copied yours it
worked. Thanks for your help!

Monika

 

[Teethless mama]

Try this:

=IF(N(G18),IF(T18/G18>0,T18/G18,"NA"),"NA")