Hi guys! Hope all of you are doing well and healthy.
I need some help here creating a formula that will help me to calculate the commissions for salespeople based on the tiers below:
Tier 1 - Sales Up to $20,000.00 - Not Eligible for Commission
Tier 2 - Greater than $20,000.01 up to $50,000.00 in Sales will pay 6% of the Excess of $20,000.01
Tier 3 - Greater than $50,000.01 up to $80,000.00 in Sales will pay 8% of the Excess of $50,000.01
Tier 4 - Greater than $80,000.01 up to $100,000.00 in Sales will pay 10% of the Excess of $80,000.01
Tier 5- Greater than $100,000.01 in Sales will pay 8% of the Excess of $100,000.01
Let me know if you need more details so that I can help you.
Thank you so much!
I need some help here creating a formula that will help me to calculate the commissions for salespeople based on the tiers below:
Tier 1 - Sales Up to $20,000.00 - Not Eligible for Commission
Tier 2 - Greater than $20,000.01 up to $50,000.00 in Sales will pay 6% of the Excess of $20,000.01
Tier 3 - Greater than $50,000.01 up to $80,000.00 in Sales will pay 8% of the Excess of $50,000.01
Tier 4 - Greater than $80,000.01 up to $100,000.00 in Sales will pay 10% of the Excess of $80,000.01
Tier 5- Greater than $100,000.01 in Sales will pay 8% of the Excess of $100,000.01
Let me know if you need more details so that I can help you.
Thank you so much!