Declining balance
Hi,
If this sheet only records expenditures, then with your initial balance in
A2, and all expenditures starting in A3 and going down the column:
In B2, enter: A2-SUM(A3:A10000)
B2 will now always display the running balance.
Change the refs to suit your data.
Hope this helps.
Regards - Dave.
|