how are you copying your formula down the sheet?
perhaps you can also tell us which columns and rows your sheet has its
1)Balance bought forward cell
2)which row and column is the first withdrawal cell
3)which row and column has the first deposit cell
4)which row and column has the first"balance" cell?
--
paul

remove nospam for email addy!



"LJB Jazz" wrote:

I tried your advice and I still can't get it to work... I just don't know
what I'm doing wrong... it comes out saying $10.00 every time and the formula
changes to =REF#!+B1-C1... any more adivce??

"Gary''s Student" wrote:

Lets say column A has the transaction date.
Column B (starting in B2) has the deposits
Column C (starting in C2) has the withdrawls
Column D will have the running balance

In D1 put 0
In D2 enter:

=D1+B2-C2 and copy down

We just take the previous balance and update it.
--
Gary's Student


"LJB Jazz" wrote:

I am trying to put together a checkbook registry much like the Excel
Checkbook Registry Template, and I know how to make the columns/ rows a
certain function (i.e. currency, date, etc.) but I can't figure out the
formula to get the running balance. If someone could help, i would greatly
appreciate it!

Jazz
P.S. I'm using MS Excel 2003.