Ckecking spreadsheet

D

Drew

Anyone have a good formula or setup to doing a simple Checkbook
register in Excel?

Thanks
 
J

JE McGimpsey

Drew said:
Anyone have a good formula or setup to doing a simple Checkbook
register in Excel?
Click to expand...

You can get one from Microsoft:

http://office.microsoft.com/en-us/templates/TC010186511033.aspx

follow the links - the template's a WinXL template in .cab format. When
you download it, use Stuffit Expander to expand the file to an .xlt XL
template file.

A basic setup might be:

A B C D E F
1 Ck # Date Description Deposit Ck/WD Balance

Then in column F enter:

F2: =SUM(D2:E2)
F3: =IF(COUNT(D3:E3),F2+D3-E3,"")

copy F3 down as far as desired.
 
E

effendrew-google

I never thought to look on Microsoft's web site. Is there a template
for Mac? I can not seem to find one.

Thanks
 
J

JE McGimpsey

I never thought to look on Microsoft's web site. Is there a template
for Mac? I can not seem to find one.
Click to expand...

Doesn't appear to be, but that WinXL template seems to work fine in
MacXL based on some very light testing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Office365 Family + TXT or MX Domain 0
Need Help with Macro Security 1
Word hyperlinks not working 2
Office add-in registration error - Component not correctly registered 0
How to automate update on weekly reports spreadsheet 0
how do i add a formula to a cell that will add or subrtact from d. 2
balance in excel that only shows the last entry 3
Email notifications without opening application 1

Top