Another rewards program that Aleeta is considering includes a way for non-club members to also earn a discount On the Transactions worksheet, in cell Q10, create a formula that will return 0.1 if the customer is a member and they spent more than $200 or if the customer simply purchased a promotional item, otherwise return a blank value 0. Format the cell as Percentage with 0 decimal places. Use the fill handle to copy the formula down through Q30