Can I get help with an excel 2003 formula
 

I have checkbook bal;ance in excel column A is Check #, Column B is check
amount, Column c is balance. Rather than go down the list of all the checks
listed but not written with the balance, how would I writed it so that if
there is no checks or deposits written to a check number then the correspond
d cell will be blank. The deposits are shown only when a check amount is
shown in b.

i.e. IF column "b" '='0 then "d" ='0

Can I get help with an excel 2003 formula
 

=IF(B1=0,"",<what you want to happen if not true) or replace the "" with 0
if you want a zero.

"miltdp" wrote:

I have checkbook bal;ance in excel column A is Check #, Column B is check
amount, Column c is balance. Rather than go down the list of all the checks
listed but not written with the balance, how would I writed it so that if
there is no checks or deposits written to a check number then the correspond
d cell will be blank. The deposits are shown only when a check amount is
shown in b.

i.e. IF column "b" '='0 then "d" ='0