To calculate rebate amount you will create an IF function with structured references in column K$.$ Enter an IF statement in cell K$6$ to determine the customers rebate. If the value in cell H$6=$ 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. You must use the semi$-$selection process to add the structured references to the formula