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

If you start with an "Opening" balance in say G2, then in G3:

=G2+F2-D2 to give a new balance.

Copy this formula down your sheet.

To avoid having results in G for future transactions you could use

=IF(aND(D2=0,F2=0),"",G2+F2-D2) which leave column G blank until either a
Debit and/or Credit is added to a row.

Does this help?

"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

Thanks! I'll give it a try and see it I can make it work.

"Toppers" wrote:

If you start with an "Opening" balance in say G2, then in G3:

=G2+F2-D2 to give a new balance.

Copy this formula down your sheet.

To avoid having results in G for future transactions you could use

=IF(aND(D2=0,F2=0),"",G2+F2-D2) which leave column G blank until either a
Debit and/or Credit is added to a row.

Does this help?

"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