Another checkbook registry problem...
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.
|