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. 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