software

I am trying to set up a formula where a commission amount is calculated based
on the amount of sales an individual makes during a period. Say, if the
sales amount is below $3000, the commission % is 1% (ie commission amount
would be $30, which is $3000x1%). If the sales amount is greater than $3000
but less than $6000, the commission % is 1.5. If the sales amount is greater
than $6000 but less than $8000, the commission % is 2%. So on and so
forth...2.5%,3%, 3.5% up to 5%. Can this formula be set up in Excel? If
anyone knows, I would appreciate if you could let me know viaor I can call you on long distance if you give me the
phone number. Best regards, John

Here's a link

www.mcgimpsey.com/excel/variablerate.html
--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Johnwquot; gt; wrote in message
...
gt;I am trying to set up a formula where a commission amount is calculated
gt;based
gt; on the amount of sales an individual makes during a period. Say, if the
gt; sales amount is below $3000, the commission % is 1% (ie commission amount
gt; would be $30, which is $3000x1%). If the sales amount is greater than
gt; $3000
gt; but less than $6000, the commission % is 1.5. If the sales amount is
gt; greater
gt; than $6000 but less than $8000, the commission % is 2%. So on and so
gt; forth...2.5%,3%, 3.5% up to 5%. Can this formula be set up in Excel? If
gt; anyone knows, I would appreciate if you could let me know via
gt; or I can call you on long distance if you give me the
gt; phone number. Best regards, JohnHi!

Is it a straight commission on the total amount or is it a cumulative rate
commission?

Which one of these:

1. total = 5000 commission is 1.5% of 5000

2. total = 5000 commission is 1% of the first 2999 plus 1.5% of the amount
from 3000 to 5000

Biff

quot;Johnwquot; gt; wrote in message
...
gt;I am trying to set up a formula where a commission amount is calculated
gt;based
gt; on the amount of sales an individual makes during a period. Say, if the
gt; sales amount is below $3000, the commission % is 1% (ie commission amount
gt; would be $30, which is $3000x1%). If the sales amount is greater than
gt; $3000
gt; but less than $6000, the commission % is 1.5. If the sales amount is
gt; greater
gt; than $6000 but less than $8000, the commission % is 2%. So on and so
gt; forth...2.5%,3%, 3.5% up to 5%. Can this formula be set up in Excel? If
gt; anyone knows, I would appreciate if you could let me know via
gt; or I can call you on long distance if you give me the
gt; phone number. Best regards, John