New Excel User: Need help with functions. Please help!!!

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
 
T

Toppers

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?
 

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