If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
PERSONAL CHECKBOOK TEMPLATE FOR EXCEL
I NEED AN EXCEL TEMPLATE TO BALLANCE A PERSONAL CHECKBOOK
|
#2
|
|||
|
|||
PERSONAL CHECKBOOK TEMPLATE FOR EXCEL
See:
http://office.microsoft.com/en-us/te...186511033.aspx -- Gary's Student "EMAN3" wrote: I NEED AN EXCEL TEMPLATE TO BALLANCE A PERSONAL CHECKBOOK |
#3
|
|||
|
|||
PERSONAL CHECKBOOK TEMPLATE FOR EXCEL
THANK YOU VERY MUCH
"Gary''s Student" wrote: See: http://office.microsoft.com/en-us/te...186511033.aspx -- Gary's Student "EMAN3" wrote: I NEED AN EXCEL TEMPLATE TO BALLANCE A PERSONAL CHECKBOOK |
#4
|
|||
|
|||
PERSONAL CHECKBOOK TEMPLATE FOR EXCEL
If you want to use that template please be aware that format in a
check book and the format in that template are setting up you account as if you are doing the books for your bank. (at least in most US checkbooks) If you were doing your own records for yourself the Dr(+) would still be on the left but indicate additions Cr(-) would still be on the right, but indicate payments out of account. In any case I would suggest that you set up formulas with offset to refer to the previous row, so that you can reorder you entires without having to rework your formulas. There is a big difference between copying a formula down and between either recopying ALL of the formulas down or copying down missing formulas only. http://www.mvps.org/dmcritchie/excel/insrtrow.htm so instead of G3: =G2+F3-E3 reversed use of Dr and Cr as in template use G3: =OFFSET(G3,-1,0) +F3-E3 reversed use of Dr and Cr as in template By the way the use of SUM for each balance would be very inefficient, and the use of SUMPRODUCT for each balance would be the same (inefficient). Checklist of things to check (#checklist) -- look for use of SUM http://www.mvps.org/dmcritchie/excel....htm#checklist for how much difference, see http://groups.google.com/groups?as_u...2@TK2MSFTNGP10 --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "EMAN3" wrote in message news THANK YOU VERY MUCH "Gary''s Student" wrote: See: http://office.microsoft.com/en-us/te...186511033.aspx -- Gary's Student "EMAN3" wrote: I NEED AN EXCEL TEMPLATE TO BALLANCE A PERSONAL CHECKBOOK |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
What is the best (easiest) personal budgeting spreadsheet template | Greyram2500 | General Discussion | 1 | June 11th, 2005 05:48 PM |
transferring checkbook template to excel | jean | Worksheet Functions | 1 | May 31st, 2005 03:41 AM |
Making a personal template. | D.DuPree | General Discussion | 0 | April 24th, 2005 03:09 AM |
Right-click-created .doc file has wrong Normal template | HONYAKUKA | General Discussion | 7 | May 25th, 2004 05:38 PM |
Mial merge data base problems | Rachael | Mailmerge | 16 | May 21st, 2004 06:22 PM |