Please help with finding correct functions!!!

D

divahammer

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
 
G

gls858

divahammer said:
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

Unless you just want the practice why not just download a template
from MS
http://office.microsoft.com/en-us/templates/TC010186511033.aspx?CategoryID=CT011815531033

Watch for line wrap.

gls858
 
D

divahammer

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!
 
G

gls858

divahammer said:
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!

That's exactly what it does. Did you even look at it?

gls858
 
G

gls858

divahammer said:
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!

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
 
P

paul

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.
=
 

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

Top