Commission Percent based on Gross Margin Percent Formula

[canselmi]

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]

Solved with following formula:
=INDEX(Commission_Range, MATCH(Input, Min_Gross_Margin, 1))

IF_AND_Formula_Test.xlsx