Nested If not returning correct values
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
|