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

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

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

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


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