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

"ben803" wrote:


this might be a stupid question to all of you excel experts out there
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 i
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.


--
ben803
------------------------------------------------------------------------
ben803's Profile: http://www.excelforum.com/member.php...o&userid=35138
View this thread: http://www.excelforum.com/showthread...hreadid=548963