Hi guys!
I need help regarding LOOKUP formula!
I have a % commision Matrix. The rows & columns are an intervals data. Rows intervals data are organizated bottom-up (bottom the lower figure, up the higher figer).
How I can get the the % of commision that one saler will get acording his results?
Thank you in advance for your help!
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>
I need help regarding LOOKUP formula!
I have a % commision Matrix. The rows & columns are an intervals data. Rows intervals data are organizated bottom-up (bottom the lower figure, up the higher figer).
How I can get the the % of commision that one saler will get acording his results?
Thank you in advance for your help!
CARS</SPAN> | |||||||
GROWTH</SPAN> | Minimum</SPAN> | 5,00%</SPAN> | 10,01%</SPAN> | 15,01%</SPAN> | 20,01%</SPAN> | 25,01%</SPAN> | |
Maximum</SPAN> | 10,00%</SPAN> | 15,00%</SPAN> | 20,00%</SPAN> | 25,00%</SPAN> | |||
TRUCKS</SPAN> | 40,01%</SPAN> | 55%</SPAN> | 90%</SPAN> | 120%</SPAN> | 140%</SPAN> | 160%</SPAN> | |
35,01%</SPAN> | 40,00%</SPAN> | 45%</SPAN> | 75%</SPAN> | 110%</SPAN> | 130%</SPAN> | 150%</SPAN> | |
30,01%</SPAN> | 35,00%</SPAN> | 35%</SPAN> | 65%</SPAN> | 100%</SPAN> | 120%</SPAN> | 140%</SPAN> | |
25,01%</SPAN> | 30,00%</SPAN> | 30%</SPAN> | 45%</SPAN> | 80%</SPAN> | 85%</SPAN> | 90%</SPAN> | |
20,00%</SPAN> | 25,00%</SPAN> | 25%</SPAN> | 30%</SPAN> | 60%</SPAN> | 65%</SPAN> | 70%</SPAN> | |
Minimum</SPAN> | Maximum</SPAN> | ||||||
REAL VALUES</SPAN> | |||||||
12,50%</SPAN> | % CARS | ||||||
32,00%</SPAN> | % TRUCKS | ||||||
65,00%</SPAN> | HOW I GET IT?</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>