need help with formula for a newbie excel guy

[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

 

[hans bal(nl)]

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

 

[Bondi]

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

 

[ben803]

thank you guys so much for your help. This definitely worked for me.
Thank you again