In C3 you could simplify the formula to:

=C2+A3-B3

then copy this down to the cells below.

Pete

Naveen wrote:
Try this ...

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

*** Please do rate ***





" wrote:

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