Probably, I'm not explaining this right... Maybe this will help a little more.
I have an employee (John Smith) who is billable to a client, I earn
commission based on his Gross Margin $.

So next to John's name I have 3 cells (AO, AM and RCR). If I am his AM, so
there is an x (CELL is M6)

GM% = 20% (CELL is K6)

GM$ = $12.68 (CELL is J6)

Monthly Hours = 160 (CELL is I6)

Here are the commissions percentages
Margin % COMMISSION
< or = 19% 4%
20% but < or = 24% 6.00%
25% but < or = 29% 8.00%
30% but < or = 34% 10.00%
35% but < or = 39% 12.00%
/= 40% 14.00%

So, if John works 160 hours in a month and his GM% is 19%, I would earn 4%
of the Gross Margin$ for every hour he works. (($12.68*0.04)*160). I need
the calculations to look at (K6) and if is it 20% but <or= 24% use 6% and so
on and so on....

Make any more sense?

Thanks for all your help on this!