Running balance!!!...?
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 |
Running balance!!!...?
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 |
Running balance!!!...?
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 |
Running balance!!!...?
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 |
Running balance!!!...?
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 |
All times are GMT +1. The time now is 03:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com