Excel Comission Calculator

I have built the basics of a calculator that sales people use to process their commission payments. (See attached) The scenario is on Sheet 1 1. Sales person enters Project Value 2. Sales Person Enters Project Cost 3. Project Margin $ is calculated automatically based on the above 4. Project Margin % is calculated Automatically based on the above 5. The data from sheet 1 pulls through to sheet 2 to populate the look up table which is our company standard commission structure The main request for this job is in the next few items. *Referencing the company commission structure look up table on Sheet 2 6. Using the Margin % in H6 you can see that it need to look up 26.76%. 7. On the look up table this would equal a Commission % of 8.5% in K6 8. The $ payable for the claim would be $2,274.18 9. $2,274.18 pulls through to Sheet 1and splits 50/50 in H9 & I9 10. Sub total and Grand total summing is also applied as an auto sum on the front page To Note: The Sheet 2 look up table has rounding involved. Anything above or below .5 of a value rounds up/down. This needs to be automated also. Using the number in the supplied spreadsheet and the values above you can see some rounding up occurred as the base margin is 26.76 [Above .5 so this rounds up] There are drop down boxes currently in Grey, these can be deleted if the form becomes fully automated. Thankyou