We learned about LOOKUP functions this semester. Use the Commission Table below to assign a commission % based on the sale price of a home in the list below using a vertical lookup function. The range B8:C15 has been named commission. Also calculate the Commision $ using Sale Price * Commission %. 5 points Commission Table Sale Price Commission Notes $0 6.00% sale price is less than $250,000 $250,000 5.75% sale price is $250,000-$349,999 $350,000 5.50% sale price is $350,000-$449,999 $450,000 5.25% sale price is $450,000-$549,999 $550,000 5.00% sale price is $550,000-$649,999 $650,000 4.75% sale price is $650,000-$749,999 $750,000 4.50% sale price is $750,000-$899,999 $900,000 4.25% sale price is $900,000 and above