Formula for a Check Register function

  • Thread starter Thread starter RAA81
  • Start date Start date
R

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
 
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
 
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
 
Back
Top