I am doing a spreadsheet where I am keeping a running, -decreasing-
balance in a column, with the figures that will be subtracted in
another column. How do I create a formula to show the balance? The
cells in the one column somehow need to be linked to that balance, but
utilizing the original number from which they are being subtracted.
HELP! and many thanks! I need this ASAP!


--
lsmith
------------------------------------------------------------------------
lsmith's Profile: http://www.excelforum.com/member.php...o&userid=31824
View this thread: http://www.excelforum.com/showthread...hreadid=550087

If A1=balance before any subtactions and column B contains the numbers
to be subtracted (starting in B2), the a simple formula could be:

A2=A1-B2
A3=A2-B3
A4=A3-B4
...

I'm not sure if this is what you had in mind, please clarify if your
problem is more complicated


--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
View this thread: http://www.excelforum.com/showthread...hreadid=550087