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" wrote:

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" wrote in message
...
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