how to get a percentage total in excel chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roberta J Smith - 25 Oct 2007 18:33 GMT

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!!

Reply to this Message

Gordon - 26 Oct 2007 08:38 GMT

>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.
[quoted text clipped - 5 lines]
> 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/training/CR100479681033.aspx

Reply to this Message

slow386 - 26 Oct 2007 15:16 GMT

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/handouts/UTOPIA_ExcelGS/

HTH
Steve

>>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.
[quoted text clipped - 11 lines]
> Alternatively, you could use the on-line tutorials that MS provide...
> http://office.microsoft.com/en-us/training/CR100479681033.aspx

Reply to this Message