How can update keep an updated balance on a spreadsheet

  • Thread starter Thread starter bug28
  • Start date Start date
B

bug28

i have a budget setup in a spreadsheet and i cant figured how to keep a
balance updated on a loan without typing in the new balance everytime
 
bug28 said:
i have a budget setup in a spreadsheet and i cant figured how to keep a
balance updated on a loan without typing in the new balance everytime
Click to expand...

It's not clear what you are trying to do. Is it something along these lines?

Put the initial loan amount in B1.
Put each repayment in column A, starting at A2.
Put this formula
=B1-A2
or this one
=IF(A2<>"",B1-A2,"")
in B2 and drag down column B as far as needed.
 
Back
Top