need help with formula for a newbie excel guy

  • Thread starter Thread starter ben803
  • Start date Start date
B

ben803

this might be a stupid question to all of you excel experts out ther
but please help me.


cell c14 = 0

cell d14 = 5

in order to get an N/A in the equation cell, here is the formula that
put it.

=IF(C14=0,"N/A",D14/C14-1)

is it possible to get a formula to have N/A if either cell is "0"???

please help, thank you
 
Instead of the condition C14=0 write OR(C14=0;D14=0)
This will return true if one or both cells are o

Does this help ?

Hans
 
Hi Ben,

You can use something like this to see if either cell is zero:

=IF(OR(C14=0,D14=0),"N/A",D14/C14-1)

Regards,
Bondi
 
Back
Top