Need help with this formula. So if Gross Margin % is 44%, commission percent would be 8%.

Tried this: =IF(E14<30%,"",IF(E14>30%,6%,IF(E14>35%,7%,IF(E14>35%,8%,IF(E14>40%,9%,IF(E14>45%,10%,IF(E14>50%,11%,IF(E14>55%,11%))))))))
But value returned is always 6%.

Gross margin % Commission $
<=29%--------->0%
30% ------------>6%
35% ------------>7%
40% ------------>8%
45% ------------>9%
50% ------------>10%
=>55% ------------>11%