Carrying a balance forward
Assuming:
Initial balance in B2 = 5000
negative amounts in B3:B99
in c2, enter:
=SUM(B$2:B2)
and copy down
HTH
--
AP
"Melanie Savasta" a écrit dans le message de
...
Good morning/afternoon to everyone
I would like calculate a balance.
Example:
$5000.00 in an account, subtracting different amounts
on different dates - I would like excel to show a
continuing balance when amounts are subtracted.
I hope this explanation is clear.
Thanks
|