ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formulas--running balance (https://www.excelbanter.com/excel-worksheet-functions/191801-formulas-running-balance.html)

BTR

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


Dave

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.


All times are GMT +1. The time now is 12:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com