Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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!! |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
"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 |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Percentage total may not exceed 100 | Excel Discussion (Misc queries) | |||
Total Revenue Percentage | Excel Discussion (Misc queries) | |||
Percentage Discount Total | Excel Discussion (Misc queries) | |||
show in a excel graphic a total percentage for 5 diff data fiels | Charts and Charting in Excel | |||
Showing the percentage of a total in Excel | Excel Discussion (Misc queries) |