Declining balance

  • Thread starter Thread starter btr
  • Start date Start date
B

btr

Can someone give me the "easiest" instructions to keep a running balance
using formulas?

Ex: Balance 125,000
Less 1,394.50
Balance
Less 2,356.89

I thought I did the following but I can't get the formula to automatically
deduct the expenditures and give a balance each and every time. This is what
I have been doing.

fx, click on sum
=Sum (K3-J3)
Copy & paste

Help me learn how to do this painlessly and quickly. Thanks
 
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.
 
I have put my beginning cell of K3 and the expenditures beginning in J5--what
now?

$85,848.82 K3

J5 $1,222.19 $84,626.63
J6 $916.00 $84,626.63
J7 $1,048.80 $84,626.63
$377.00 $84,626.63
$62.70 $84,626.63
$400.85 $84,626.63
$180.00 $84,626.63
$479.07 $84,626.63
$177.84 $84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
 
Ok, in K5 enter:
=IF(J5="","",$K$3-SUM($J$5:$J5))
Then fill down way past the bottom of your data in Column J
Let me know.
Dave.
 
this did not work. I typed in exactly what you have below (do I need to
insert the actual dollar amount where you have the $ sign?)
 
I did this and got $84,626.63 and filled this amount all the way down to at
least J27 but when I put in my next expenditure it does not change the
balance. Any other suggestions other than using a calculator?
 
Hi,
It really does work. I've tested it.
Yes, you need all the $ signs.
It's better if you highlight the formula straight off this page, then copy,
then double click in cell K5, then paste, then enter, then copy down.

=IF(J5="","",$K$3-SUM($J$5:$J5))

But just one question: are the balances you have already, as shown in your
data, in Column K? If so, save the workbook, delete them, then proceed as
above.

Regards - Dave.
 
Back
Top