If statements for a range!

[polarisboy385]

SO i need somehelp,
im trying to get a commissions % chart built. i have all the info i need, and formulas but i'm stumped with how to work this out

bascially i need excel to figure out that if a specific amount of unit sales % fals within X range that it equates out to Y profit range, but the Y range can only be rounded down.

<table width="508" border="0" cellpadding="0" cellspacing="0" height="333"><colgroup><col style="mso-width-source:userset;mso-width-alt:2633;width:54pt" width="72"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:2633; width:54pt" width="72" span="2"> </colgroup><tbody><tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt;width:54pt" width="72" height="17">% of Quota</td> <td class="xl24" style="border-left:none;width:56pt" width="75">Payment %</td> <td class="xl24" style="border-left:none;width:54pt" width="72">% of Quota</td> <td class="xl24" style="border-left:none;width:54pt" width="72">Payment &</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl25" style="height:12.75pt" align="right" height="17">30.0%</td> <td class="xl25" align="right">15.0%</td> <td class="xl25" align="right">120.0%</td> <td class="xl25" align="right">130.0%</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl25" style="height:12.75pt" align="right" height="17">35.0%</td> <td class="xl25" align="right">15.0%</td> <td class="xl25" align="right">125.0%</td> <td class="xl25" align="right">137.5%</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl25" style="height:12.75pt" align="right" height="17">40.0%</td> <td class="xl25" align="right">15.0%</td> <td class="xl25" align="right">130.0%</td> <td class="xl25" align="right">145.0%</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl25" style="height:12.75pt" align="right" height="17">45.0%</td> <td class="xl25" align="right">45.0%</td> <td class="xl25" align="right">135.0%</td> <td class="xl25" align="right">152.5%</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl25" style="height:12.75pt" align="right" height="17">50.0%</td> <td class="xl25" align="right">45.0%</td> <td class="xl25" align="right">140.0%</td> <td class="xl25" align="right">160.0%</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl25" style="height:12.75pt" align="right" height="17">55.0%</td> <td class="xl25" align="right">45.0%</td> <td class="xl25" align="right">145.0%</td> <td class="xl25" align="right">167.5%</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl25" style="height:12.75pt" align="right" height="17">60.0%</td> <td class="xl25" align="right">60.0%</td> <td class="xl25" align="right">150.0%</td> <td class="xl25" align="right">175.0%</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl25" style="height:12.75pt" align="right" height="17">65.0%</td> <td class="xl25" align="right">60.0%</td> <td class="xl25" align="right">155.0%</td> <td class="xl25" align="right">182.5%</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl25" style="height:12.75pt" align="right" height="17">70.0%</td> <td class="xl25" align="right">60.0%</td> <td class="xl25" align="right">160.0%</td> <td class="xl25" align="right">190.0%</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl25" style="height:12.75pt" align="right" height="17">75.0%</td> <td class="xl25" align="right">75.0%</td> <td class="xl25" align="right">165.0%</td> <td class="xl25" align="right">197.5%</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl25" style="height:12.75pt" align="right" height="17">80.0%</td> <td class="xl25" align="right">75.0%</td> <td class="xl25" align="right">170.0%</td> <td class="xl25" align="right">205.0%</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl25" style="height:12.75pt" align="right" height="17">85.0%</td> <td class="xl25" align="right">75.0%</td> <td class="xl25" align="right">175.0%</td> <td class="xl25" align="right">212.5%</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl25" style="height:12.75pt" align="right" height="17">90.0%</td> <td class="xl25" align="right">90.0%</td> <td class="xl25" align="right">180.0%</td> <td class="xl25" align="right">220.0%</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl25" style="height:12.75pt" align="right" height="17">95.0%</td> <td class="xl25" align="right">90.0%</td> <td class="xl25" align="right">185.0%</td> <td class="xl25" align="right">227.5%</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl25" style="height:12.75pt" align="right" height="17">100.0%</td> <td class="xl25" align="right">100.0%</td> <td class="xl25" align="right">190.0%</td> <td class="xl25" align="right">235.0%</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl25" style="height:12.75pt" align="right" height="17">105.0%</td> <td class="xl25" align="right">107.5%</td> <td class="xl25" align="right">195.0%</td> <td class="xl25" align="right">242.5%</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl25" style="height:12.75pt" align="right" height="17">110.0%</td> <td class="xl25" align="right">115.0%</td> <td class="xl25" align="right">200.0%</td> <td class="xl25" align="right">250.0%</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl25" style="height:12.75pt" align="right" height="17">115.0%</td> <td class="xl25" align="right">122.5%</td> <td class="xl25">

</td> <td class="xl25">
</td> </tr><tr><td valign="top">
how would i put together that formula




</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td></tr> </tbody></table>

 

[polarisboy385]

I also need this all for one cell lol