Something like below?
Personally, I'd prefer to insert a line at the top, push the old data down
and have the current stuff on top, but that's just me ...
A1: ### - some value
B1: +A1
C1: +B10
A2: ### - some value
B2: +B1-A2
A3: ### - some value
B3: +B2-A3
A4: ### - some value
B4: +B3-A4
.
.
.
A10: ### - some value
B10: +B9-A10
-----Original Message-----
From: Mark Rode [mailto:[log in to unmask]]
Sent: Tuesday, October 24, 2000 7:21 PM
To: [log in to unmask]
Subject: [PCSOFT] Excel Formula
I am trying to set up two columns in Excel 2000 to calculate a running
balance.
Say you have Column A and column B.
You input a figure in cell A2 which is automatically subtracted from B1 and
then the result is outputted to B2 and this continues down the entire
column....input in A3 which is subtracted from B2 and inputted to B3 etc.
I would also like to output the result (running balance) to a single cell
at the top of the worksheet so I can always see the balance when i open it
...Say C1.
I assume this can all be done with a formula in the B column but how do
this so that it keeps running down the column ?
thanks
Mark Rode
Curious about the people moderating your
messages? Visit our staff web site:
http://nospin.com/pc/staff.html
Do you want to signoff PCSOFT or just change to
Digest mode - visit our web site:
http://nospin.com/pc/pcsoft.html
|