View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default 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