Can I get help with an excel 2003 formula

G

Guest

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top