if one cell equals zero then the next cell should say N/A
 

I use excel to take care of the household budget. When a balance on an
account is zero then no payment is needed. I also use it to list the date
paid and the date it cleared our checking account. If the cell for the
balance is zero, I have to manually enter N/A for the date paid and the date
cleared.
So assuming that the cell A2 is the balance of Zero, I would like B2 and C2
to automatically read N/A. However if the cell A2 is anything over zero,
then it should leave the cells B2 and C2 blank.

Anyone have any ideas on how to accomplish that? It doesn't have to read
N/A it can also read 0 (zero) if it would make calculations simpler.

Thanks for any help you can be.

if one cell equals zero then the next cell should say N/A
 

=IF($A2=0,"N/A","") that is a pair of double quotes before the
closing )
Put in B2 and drag it to C2
Copy both down the columns
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"TeddyBearDJ" wrote in message
...
I use excel to take care of the household budget. When a balance on an
account is zero then no payment is needed. I also use it to list the date
paid and the date it cleared our checking account. If the cell for the
balance is zero, I have to manually enter N/A for the date paid and the
date
cleared.
So assuming that the cell A2 is the balance of Zero, I would like B2 and
C2
to automatically read N/A. However if the cell A2 is anything over zero,
then it should leave the cells B2 and C2 blank.

Anyone have any ideas on how to accomplish that? It doesn't have to read
N/A it can also read 0 (zero) if it would make calculations simpler.

Thanks for any help you can be.