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

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

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
wrote in message
oups.com...
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

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

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

Check out the following link (you will need to copy and paste it into your
browser), http://office.microsoft.com/en-us/as...001271033.aspx

One of the formulas listed on this page is for keeping a running balance.

" 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