Formulas--running balance

[btr]

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]

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.