Running balance!!!...?

C

cleggy

Deposit Withdrawal Running Balance
10 2 8
5 3
2 1
AND SO ON EVEN IF IT GETS INTO AN OVERDRAFT AMOUNT something like the
bank statements eg Debit Amount Credit Amount Balance
Can anyone please help with a formula that can do this?
Please!
Regards
cleggy
 
R

Ragdyer

One way you could try is entering this in C2, and copy down as needed:

=SUM($A$2:A2)-SUM($B$2:B2)
 
N

Naveen

Try this ...

Column:A B C
Deposit Withdrawal Running Balance
10 2 =A2-B2
5 =IF(A3>0,A3+C2-B3,C2-B3)
2 =IF(A4>0,A4+C3-B4,C3-B4)
(Copy this to below cells.)

*** Please do rate ***
 
P

Pete_UK

In C3 you could simplify the formula to:

=C2+A3-B3

then copy this down to the cells below.

Pete
 
Top