>
> >GregChi <[EMAIL PROTECTED]> skrev den Fri, 20 May 2005 15:46:01 -0400:
> >
> >> In a check register I want a formula in cell A1 to show the last
> >> value in the column(D?) that is the current balance. As more data is
> >> entered this last item will be shifted down. Until data is entered the
> >> cell is empty.
> >> Is there a function/formula for this?
> >
You can get what you want by reconstructing the last number in Column
D (your account balance)
Add together:
The first active cell in column D (your balance forward) &
The sum of all the cells on the page in Column B (your deposits)
Subtract
The sum of all the cells on the page in Column C (your disbursements)
Thus, the formula in Cell A1 would look something like
=D3+sum(B3:B200)-sum(C3:C200)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
