Question: Aleeta is considering rolling out a Rewards Program to replace all of the individual discounts and coupons. One option she is considering is focused on

Aleeta is considering rolling out a Rewards Program to replace all of the individual discounts and coupons. One option she is considering is focused on club members. On the Transactions worksheet, in cell P10, create a formula that will return 0.1 if the customer is a member and they either purchased a promotional item or spent more than $100, otherwise return a value of 0. Format the cell as Percentage with 0 decimal places. Use the fill handle to copy the formula down through P30
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
