Not sure if I can do this with a formula or VBA.
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%
Bookmarks