How can update keep an updated balance on a spreadsheet

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
 
S

Stephen

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