ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how to get a percentage total in excel chart (https://www.excelbanter.com/new-users-excel/163508-how-get-percentage-total-excel-chart.html)

Roberta J Smith

how to get a percentage total in excel chart
 
I am making a sheet on my real estate sales. I want to take the amount in
column 5 (sold price) and have my commission amount show up in column 8. the
formula is example $179900 x 62% - 6.2% = my commission. How do I do this
and what box do I do it in. I want each row to have its own total and at
bottom of page have a sum total. I do not what a ruynning total in column 8.
I am so new at this I am totally lost. I bought Microsoft 2007 Pro so I
want to use it. thanks for help!!

Gordon

how to get a percentage total in excel chart
 
"Roberta J Smith" wrote in message
...
I am making a sheet on my real estate sales. I want to take the amount in
column 5 (sold price) and have my commission amount show up in column 8.
the
formula is example $179900 x 62% - 6.2% = my commission. How do I do this
and what box do I do it in. I want each row to have its own total and at
bottom of page have a sum total. I do not what a ruynning total in column
8.
I am so new at this I am totally lost. I bought Microsoft 2007 Pro so I
want to use it. thanks for help!!



May I suggest that if you really are that clueless about spreadsheets then
you toddle off to your local bookstore and buy and read Excel for Dummies.
Alternatively, you could use the on-line tutorials that MS provide...
http://office.microsoft.com/en-us/tr...479681033.aspx



slow386

how to get a percentage total in excel chart
 
Roberta:
These are mostly geared to 2000 and 2003, but they're basic and may get you
started.
The first link is probably the best . . .
http://www.usd.edu/trio/tut/excel/

http://people.stfx.ca/rjmackin/info130/excel1.htm

http://www.utexas.edu/its/training/h...TOPIA_ExcelGS/

HTH
Steve

"Gordon" wrote in message
...
"Roberta J Smith" wrote in
message ...
I am making a sheet on my real estate sales. I want to take the amount in
column 5 (sold price) and have my commission amount show up in column 8.
the
formula is example $179900 x 62% - 6.2% = my commission. How do I do
this
and what box do I do it in. I want each row to have its own total and at
bottom of page have a sum total. I do not what a ruynning total in
column 8.
I am so new at this I am totally lost. I bought Microsoft 2007 Pro so I
want to use it. thanks for help!!



May I suggest that if you really are that clueless about spreadsheets then
you toddle off to your local bookstore and buy and read Excel for Dummies.
Alternatively, you could use the on-line tutorials that MS provide...
http://office.microsoft.com/en-us/tr...479681033.aspx





All times are GMT +1. The time now is 06:31 AM.

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