Full Version: Running Balance
UtterAccess Discussion Forums > Microsoft® Office > Microsoft Excel
anish
Hi,

Please find attached file. I require some help in creating a running balance.

See File attached, For Example Cell I5 Displays Cash in Hand, an entry has been made in Money In cell E6, what i want is that E6 Entry to be added to the previous balance and a new total to be displayed in Cell I6, the same applied to I7, but in this case as money has gone out (Cell G7), I7 should calculate balance on I6 - G7 and new total to be displayed on I7.

I would be very grateful if somebody can provide me with a formula and incorporate and explain in the file attached. Many Thanks in advance!


Kind Regards,

Anish
Grove
Is this what you are after?

Edited by: Grove on 02.28.04.
anish
Aha, cool, Thanks very much Grove. :-))))
Grove
You're Welcome
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.