Subtracting a running Balance

  • Thread starter Thread starter TW
  • Start date Start date
T

TW

I am buying a car and I want to put the payments that i am making on a
worksheet that will automatically subtract my payments from the original
amount, lets say I am paying 5,500 paying 50.00 a week how can i create this
worksheet?
 
Here's one way:

A1 = header = Starting Balance
B1 = 5500

A2 = header = Total Paid to Date
B2 = formula: =SUM(B6:B300)

A3 = header = Current Balance
B3 = formula: =B1-B2

A5 = header = Date
B5 = header = Amount Paid

Select cell A6
Goto the menu Window>Freeze Panes

As you make payments and scroll down the sheet your balance will always be
visible on top.
 
Back
Top