Running balance in a checkbook worksheet
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? -- Thanks so much. |
Running balance in a checkbook worksheet
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) "shseats" wrote in message ... 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? -- Thanks so much. |
Running balance in a checkbook worksheet
Layout of your checkbook? Your formulas -- Don Guillett Microsoft MVP Excel SalesAid Software "shseats" wrote in message ... 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? -- Thanks so much. |
All times are GMT +1. The time now is 02:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com