The question now ... is the commission paid on the *entire* sales amount,
OR
Is the 5% paid on *only* the first 100 to 200 dollars,
And 10% paid on *only* the 200 to 300 dollars sales amount ... etc.?
If this be the case, check out John's link at:
http://www.mcgimpsey.com/excel/variablerate.html
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"Peter" wrote in message
...
How do I calculate commissions for employees if the following were to occur:
If an employee has 0-100 dollars in sales, there is no commission.
If an employees has 100-200 dollars in sales, there is a 5% commission.
If an employee has 200-300 dollars in sales, there is a 10% commission.
If an employee has 300+ dollars in sales, there is a 15% commission.
Peter