View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
murkaboris murkaboris is offline
external usenet poster
 
Posts: 76
Default Nested If not returning correct values

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