Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Declining balance
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Declining balance
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 "Dave" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Declining balance
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Declining balance
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?) "Dave" wrote: 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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Declining balance
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? "Dave" wrote: 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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Declining balance
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Balance | Excel Discussion (Misc queries) | |||
Trial Balance | Excel Discussion (Misc queries) | |||
Running balance!!!...? | Excel Worksheet Functions | |||
Numbers in the balance!! | Excel Worksheet Functions | |||
rent received/balance owed/running balance spreadsheet | Excel Discussion (Misc queries) |