Formula for a Check Register function

[RAA81]

Your right, sory about that.

Here is the basic layout I am going for

_Withdrawal______ | _Deposit_ _____| _Balance_ (total)
_______$10_____|_____$10____|___$20
_______$20_____|_____$15____|___$15
_______________|____________|________
_______________|____________|________


Basically just like a check book register. I need the Balance column t
display the total of the Withdrawal(negative) and the Deposit (positive
added to whatever the balance was in the previous row. Also, isnt ther
a better way than to manually alter the formula in the Balance colum
for each new row? Again thanks for any suggestions you might have

 

[David McRitchie]

See http://www.mvps.org/dmcritchie/excel/insrtrow.htm
for an example you would have to reverse the Deposit
and withdrawal if your purpose is to keep records for the
bank rather than for yourself.

 

[tghcogo]

Hi there, perhaps I'm seeing this too simplisticly, however:

Row 1 will be your headers
Cell C2 will show your opening balance
The formula in C3 will be =C2-A3+B3
The formula in C4 will be=C3-A4+B

 

[David McRitchie]

Hi there, perhaps I'm seeing this too simplistically, ...

Yes, I think so, because your formulas prevent simple
insertion and deletion of lines without reworking the formulas.

instead of C3: =C2-A3+B3
-- use this C3: =OFFSET(C3,-1,0)-A3+B3

use the fill handle to propagate down
for insertions and more information see my previous post in this thread