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