ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   New to Excel: Need help finding functions. Please Help!!! (https://www.excelbanter.com/excel-worksheet-functions/108051-new-excel-need-help-finding-functions-please-help.html)

divahammer

New to Excel: Need help finding functions. Please Help!!!
 
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

New to Excel: Need help finding functions. Please Help!!!
 
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


divahammer

New to Excel: Need help finding functions. Please Help!!!
 
"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



All times are GMT +1. The time now is 02:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com