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
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