Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
PERSONAL CHECKBOOK TEMPLATE FOR EXCEL
I NEED AN EXCEL TEMPLATE TO BALLANCE A PERSONAL CHECKBOOK
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bi-Weekly Personal Budget Template | Excel Discussion (Misc queries) | |||
What is the best (easiest) personal budgeting spreadsheet template | Excel Discussion (Misc queries) | |||
how do i add cells in checkbook register template with formulas? | Excel Worksheet Functions | |||
transferring checkbook template to excel | Excel Worksheet Functions | |||
Personal format of an excel spreadsheet as a template? | New Users to Excel |