View Single Post
  #5   Report Post  
Peter
 
Posts: n/a
Default how to calculate commissions

What if the commission was based on only a portion of the sales. For ex: the
person earns a 10% commission on sales between $200-$300, and 15% on sales
between $300-$400?

Peter

"Ron Coderre" wrote:

You might want to use a lookup table:

On a separate worksheet (in the same wkbk) build this table:
Col_A Col_B

Base Pct
$0 0%
$100 5%
$200 10%
300 15%

Select those cells and name them:
InsertNameDefine
Name: LU_ComRate

To calculate commission percent:
Select sheet with amounts.
Assuming the commission base amount is in Cell A1:
B2: =VLOOKUP(A1,LU_ComRate,2,1)

Does that help?

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron


"Peter" wrote:

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