Running balance in a checkbook worksheet

[shseats]

I am a beginner where excel is concerned. I have created a worksheet that
has a running balance of my checking account, and I have been able to create
the needed formulas to aaccomplich my task. My problem rests when I have
more than 30 days in a month, considering that only 30 variables are allowed
in a function. How do I remedy this?

 

[Chip Pearson]

If you are running up against a problem with having 30 variables, you are
probably not doing this right. You can create a simple check register as
follows:

In cell A1, enter "Description"
In cell B1, enter "Deposits"
In cell C1, enter "Checks"
In cell D1, enter your beginning balance.

In cell D2, enter

=IF(A2="","",D1+B2-C2)

Select cells D2 to D400 or however many rows you want and press CTRL D to
fill the formula down.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Don Guillett]

Layout of your checkbook?
Your formulas