| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up a running balance worksheet ? | Excel Worksheet Functions | |||
| How do I get the checkbook register to keep a running balance? | Excel Worksheet Functions | |||
| how do i create a running balance on checkbook register | Excel Discussion (Misc queries) | |||
| How do i get the running balance from one worksheet to another? | Excel Worksheet Functions | |||
| subtract a running balance from a SUM at the bottom of worksheet | Excel Worksheet Functions | |||
Linear Mode
