canselmi
01-15-2019, 01:07 PM
Not sure if I can do this with a formula or VBA. Would rather use a formula.
I need to set a commission Percentage based on a Gross Margin percent.
So, if Cell A1 equals 44%, the commission percentage would be 8% following the list below:
Gross Margin Commission Percentage
Between 30% and 35% ---------------->6%
Between 35% and 39% ---------------->7%
Between 40% and 44% ---------------->8%
Between 45% and 49% ---------------->9%
Between 50% and 54% ---------------->10%
55% and above ------------------------->11%
I need to set a commission Percentage based on a Gross Margin percent.
So, if Cell A1 equals 44%, the commission percentage would be 8% following the list below:
Gross Margin Commission Percentage
Between 30% and 35% ---------------->6%
Between 35% and 39% ---------------->7%
Between 40% and 44% ---------------->8%
Between 45% and 49% ---------------->9%
Between 50% and 54% ---------------->10%
55% and above ------------------------->11%