Need help with Excel function for Budget

S

Sharon

I am creating a budget in Excel. Column A=description of
item purchased. Column B=Cost Column C=Balance.

So C3=Starting Balance. Then in A4 I type an item. B4 I
type a cost. C4 is =Sum(C3-B4). That gives me the Balance
in C4.

Then I fill down all cells in Column C so that the formula
is in every cell. The problem is that the Balance shows in
EVERY cell. I want the formula to be in all the column C
cells without showing the Balance unless something is
typed into Column A and Column B.

Can anyone tell me how to do that?

Sharon
 
N

Nick Hodge

Sharon

I use...

=IF(AND(A4="",B4=""),"",C3-B4)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
G

Guest

Perfect! It did exactly what I wanted to do.

I am assuming that "" means that their is SOMETHING in the
cell. So I understand that it means IF there is SOMETHING
in A4 and B4 then you put SOMETHING in the Balance Cell
(C). Am I close?

Sharon
 

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