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 P10, 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 (""). Format the cell as Percentage with 0 decimal places. Use the fill handle to copy the formula down through P30.

A B D E F H 1 K L M N 0 T382P 5% Local Magazine Promotion Reward Program Discounts Rewards1 Rewards2 Quantity CashDisc 15% 796 1 Transaction Analysis 2 3 Coupons 4 CouponCode T453X C384R 5 Discount 15% 10% Online Travel Travel Agent 6 Coupon Notes Promotion Promotion 7 8 9 TransID ItemID Payment Type 10 P000100 C884P23 Cash 11 P000101 T822248 Cash 12 P000102 F232P37 Apple Pay 13 P000103 C583K29 Apple Pay 14 P000104 F232P37 Cash 15 P000105 F375P67 Cash 16 P000106 X740029 Apple Pay 17 P000107 T981011 Cash 18 P000108 C884P23 Cash 19 P000109 X487248 Apple Pay 20 P000110 R483P24 Apple Pay 21 P000111 R483P24 Card 22 P000112 X349R39 Apple Pay 23 P000113 F833K19 Apple Pay 24 P000114 R239T57 Card 25 P000115 C583K29 Card 26 27 28 29 30 15% 15% CouponCode ClubMember? Promoltem? 3 T453X No No 2 2 No Yes 1 Yes No 3 No Yes 3 T453X No No 3 T453X Yes No 1 Yes Yes - 1 No No 2 No No 3C384R No Yes 10384R No No 1 T453X Yes No 3/T382P No Yes 3T382P No No 2 T453X No No 1 No Yes GrossRevenue Member Disc Coupon $ 171.00 $ 65.90 $ 129.00 $ 177.00 $ 387.00 $ 46.35 7% $ 453.00 7% $ 12.00 $ 114.00 $ 1,257.00 $ 2.00 $ 2.00 7% $ 149.85 $ 17.85 $ 194.00 $ 59.00 NetRevenue TotalDiscounts $ 136.80 $ 34.20 $ 65.90 $ $ 119.97 $ 9.03 $ 177.00 $ 5% $ 309.60 $ 77.40 $ 36.15$ 10.20 $ 421.29 $ 31.71 $ 12.00 $ 5% $ 108.30 $ 5.70 $ 1,131.30$ 125.70 $ 1.80 $ 0.20 $ 1.56S 0.44 $ 142.36 $ 7.49 $ 16.96 $ 0.89 $ 164.90 $ 29.10 $ 59.00 $ 10% 10% 15% 5% 596 5% 15%