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.

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.

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.

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.

Try this, it works if you delete rows later, and shows zero if there is no
date in column A

=IF(ISBLANK(A2),0,SUM($B$2:B2)-SUM($C$2:C2))

Regards
Peter
"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.

I already have this done, probably in more details then you are trying to do.
My spreadsheet calculates the difference between the ending balance in the
spreadsheet vs the ending balance that you indicate for the check register.
Also pulls the ending balance from the previous register (in spreadsheet) to
make beginning balance in new register and more. If you would like me to
email you my copy (template), I will with instructions on how it works.

Les

"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.