If function help

  • Thread starter Thread starter jvioral
  • Start date Start date
J

jvioral

What I am trying to do is this...

=IF(Calc!A503=0,"n/a",Calc!A503/'2003'!D504)

my issue is how do I get this to also show n/a when '2003'!D504 is a 0

thanks in advance!
Jase
 
If I am understanding your forumla correctly, you are
trying to avoid the #Div/0! return when the divisor is a
zero? If there's a better way, I'm sure others will
comment, but I do the following work around to avoid the
#div/0!...

Nest a check for that 0 divisor, then insert your original
formula in the later part of the equation as follows:

=If('2003'!D504=0,"n/a",IF(Calc!A503=0,"n/a",Calc!
A503/'2003'!D504))
 
Back
Top