PDA

View Full Version : [SOLVED] Commission Percent based on Gross Margin Percent Formula



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%

canselmi
01-15-2019, 04:09 PM
Solved with following formula:
=INDEX(Commission_Range, MATCH(Input, Min_Gross_Margin, 1))

23559