UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Running Balance    
 
   
anish
post Feb 28 2004, 01:16 PM
Post #1

UtterAccess Addict
Posts: 104
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
Attached File(s)
Attached File  test.zip ( 6.61K ) Number of downloads: 5
 
Go to the top of the page
 
+
Grove
post Feb 28 2004, 01:27 PM
Post #2

UtterAccess Veteran
Posts: 348
From: NW Iowa, USA
Is this what you are after?

Edited by: Grove on 02.28.04.
Attached File(s)
Attached File  test.zip ( 6.78K ) Number of downloads: 25
 
Go to the top of the page
 
+
anish
post Feb 28 2004, 03:21 PM
Post #3

UtterAccess Addict
Posts: 104
Aha, cool, Thanks very much Grove. :-))))
Go to the top of the page
 
+
Grove
post Feb 28 2004, 07:14 PM
Post #4

UtterAccess Veteran
Posts: 348
From: NW Iowa, USA
You're Welcome
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 08:24 PM