To calculate the rebate amount, you will create an IF function with structured references in column K. Enter an IF statement in cell K6 to determine the customer's rebate. If the value in cell H6 is equal to "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.