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

You have a reply .misc.

Please do not post in more than one NG to avoid duplicate replies and
potentially wasting respondents' time. Thank you.

"divahammer" wrote:

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

"Toppers",
I am sorry you felt I wasted your time. I was desperate for help, new to
forums and wasn't sure which discussion topic would result in an answer to my
question. At least an answer that I can understand. Your help was greatly
appreciated. I haven't given it a try get, but I will.
Good day,
Heidi

"Toppers" wrote:

You have a reply .misc.

Please do not post in more than one NG to avoid duplicate replies and
potentially wasting respondents' time. Thank you.

"divahammer" wrote:

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