Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas--running balance
I have pasted below a problem that I have in setting formulas to give me a
running balance after each expenditure. Can anyone give me some simple instructions in writing on how to do this? Encumbered Running or Paid Balance $85,848.82 $1,222.19 $84,626.63 $916.00 $84,626.63 $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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas--running balance
Hi,
If your original balance ($85,848.82) is in A2 and your first expenditure is in A4, then in B4 enter: =IF(A4="","",$A$2-SUM($A$4:$A4)) and copy down. Regards - Dave. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Balance | Excel Discussion (Misc queries) | |||
running balance | New Users to Excel | |||
rent received/balance owed/running balance spreadsheet | Excel Discussion (Misc queries) | |||
How do i set up a running balance on one row? | Excel Worksheet Functions | |||
running balance | New Users to Excel |