$10$ To calculate rebate amount you will create an If function with structured references in column K$.$

Enter an IF statement in cell $K6$ to determine the customers rebate. If the value in cell $H6=$ Promotion the customer receives a $10\%$ rebate on the total purchase $($Purchase Price $*$ Quantity ${?}^{**}$ Rebate$)$ if they are not eligible the function should return $0.$ Be sure to use the appropriate structured references and then use the fill handle to copy the function down completing the column.