Need help with Excel function for Budget

[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

 

[Nick Hodge]

Sharon

I use...

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

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

 

[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