 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2006Please help with finding correct functions!!!
I am trying to configure Excel to balance my checkbook. Column A is Trans. Type, Column B is Date, Column C is Description of Trans., Column D is Debits, Column E lists if items are posted, Column F is Debits and Column G is Balance. I'm trying to get Column D (debits) to subtract from Column G (balance) and get a new balance (new column? H?) and get Column F (credits) to add to Column G (balance to get a new balance (again, new column? H?). I am not computer illiterate and I should be able to figure this out by myself. But I've been working on finding the right functions (linest, subtotal, etc.) and the way to phrase the functions to get what I want. Please help me, I am so frustrated I want to through the computer out the window! Thanks so much! Heidi > I am trying to configure Excel to balance my checkbook. Column A is Trans. > Type, Column B is Date, Column C is Description of Trans., Column D is [quoted text clipped - 9 lines] > Thanks so much! > Heidi Unless you just want the practice why not just download a template from MS http://office.microsoft.com/en-us/templates/TC010186511033.aspx?CategoryID=CT011 815531033 Watch for line wrap. gls858 I'd rather use a program that will add and subtract trans for me. Sometimes I goof with my math and it takes me so much time to go over it to find my error. Thanks anyway! > > I am trying to configure Excel to balance my checkbook. Column A is Trans. > > Type, Column B is Date, Column C is Description of Trans., Column D is [quoted text clipped - 17 lines] > > gls858 > I'd rather use a program that will add and subtract trans for me. Sometimes > I goof with my math and it takes me so much time to go over it to find my [quoted text clipped - 20 lines] >> >> gls858 That's exactly what it does. Did you even look at it? gls858 > I'd rather use a program that will add and subtract trans for me. Sometimes > I goof with my math and it takes me so much time to go over it to find my [quoted text clipped - 20 lines] >> >> gls858 Another option would be to find an older copy of Quicken. I bought an older version for $5 on ebay. I just use the check register so it work fine for me. Also makes reconciliation really easy. gls858 in your balance column or somewhere you need to put a formula assuming two things say we are sarting at row 3 and your column d is debits and f is credits.I dont know what you mean by posted. in cell g3 i assume you have a "balance bought forward" number so you r formula in g4 is =$g$3-d4+f4 the formula in g5 is g4-d5+f5 copy down as far as you want. =  Signaturepaul paul.shepherd@nospamparadise.net.nz remove nospam for email addy! > I am trying to configure Excel to balance my checkbook. Column A is Trans. > Type, Column B is Date, Column C is Description of Trans., Column D is [quoted text clipped - 9 lines] > Thanks so much! > Heidi |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.