Mark,
the formula you want in B2 is ... obviously ... =B1-A2. To get this to
continue down the page, click the cell B2 once and put the mouse over the
little square in the bottom right - the "fill handle" - and drag down. The
cell references are automatically adjusted.

If you are prepared to have a fix number of rows, say 50, your other reqt is
easy: set C1 to =B50. But otherwise it may be tough. You could try another
approach altogether: =B1-SUM(A:A) - as long as you have no other values in
column A.

Joe

> -----Original Message-----
> 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

             Do you want to signoff PCSOFT or just change to
                    Digest mode - visit our web site:
                    http://nospin.com/pc/pcsoft.html