Excel formula with commission based tiers
Hello!
I can’t wrap my head around how to create this formula.
In cell I20 I have an employee’s net sales. In I21 I want to create a formula that will give their commission earnings.
So for example, if the employee has $132,000 in annual sales, their commission tier would be 2%, BUT they wouldn’t just get a blanket 2% on their annual sales. They would have 0% commission on the first $50,000, 1% on the $50k-100k, etc.
Thank you!
Hello! I can’t wrap my head around how to create this formula. In cell I20 I have an employee’s net sales. In I21 I want to create a formula that will give their commission earnings. So for example, if the employee has $132,000 in annual sales, their commission tier would be 2%, BUT they wouldn’t just get a blanket 2% on their annual sales. They would have 0% commission on the first $50,000, 1% on the $50k-100k, etc. Thank you! Read More
