| On the Transactions worksheet, in cell H10, replace the static value by entering a VLOOKUP function to retrieve the Item's price from the Product_List table and then multiply it by the quantity to calculate the gross revenue. Use the fill handle to copy the formula down through H30. |
| On the Transactions worksheet, in cell J10, replace the static value by entering a HLOOKUP function to retrieve the discount value from the range B4:D6 based on the coupon code used in the transaction. Use the fill handle to copy the formula down through J30. |
for 617 : * 1 Product List C D 2 Retail Price $ 49.95 $ 419.00 12.00 $ 49.00 $ 59.00 2.00 5.95 15.45 3 ItemID 4 X349R39 5 X487P48 6 T981Q11 7 C584123 8 C583K29 9 R483P24 10 F833K19 11 F375P67 12 C483T89 13 C492R32 14 C581149 15 C557P29 16 T822748 17 X733R14 18 X740029 19 F232P37 20 C884P23 21 R239557 Description Windbreaker (Resort) Windren Pro (right-handed) Resort golf balls Trimble Comforts Trimbel Striders Resort Tees Resort divot key chain Grabber golf gloves Resort cap Resort polo shirt golf shoe insert golf button, shirt golf button, shirt golf button, shirt Windren pro (left-handed) Resort golf bag (elite) Resort golf bag (carryall) Resort golf easy-go pull cart Category Clothing Clubs Accessories Shoes Shoes Accessories Accessories Accessories Clothing Clothing Accessories Clothing Clothing Clothing Clubs Accessories Accessories Accessories 14.95 39.95 11.39 32.95 32.95 32.95 453.00 129.00 57.00 97.00 $ $ H10 - : X fix 171 F G H I J K L M N 1 Transaction Analysis 3 Coupons 4 CouponCode 5 Discount T453X 15% C384R 10% T382P 5% Local Magazine Promotion Online Travel Promotion Travel Agent Promotion 6 Coupon Notes Coupon 15% PaymentType Quantity Cash Cash Apple Pay Apple Pay Cash Cash Apple Pay Reward Program Discounts Rewards1 Rewards2 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 15% 8 9 TransID 10 P000100 11 P000101 12 P000102 13 P000103 14 P000104 15 P000105 16 P000106 17 P000107 18 P000108 19 P000109 20 P000110 21 P000111 22 P000112 23 P000113 24 P000114 25 P000115 ItemID C884P23 T822748 F232P37 C583K29 F232P37 F375P67 X740029 T981Q11 C884P23 X487P48 R483P24 R483P24 X349R39 F833K19 R239T57 C583K29 Cash CouponCode Club Member? Promoltem? GrossRevenue Member Disc 3 T453X $ 171.00 $ 65.90 $ 129.00 79 177.00 T453X 387.00 3 T453X 46.35 7% $ 453.00 7% $ 12.00 114.00 $ 1,257.00 1 C384R 2.00 T453X 2.00 7% T382P $ 149.85 $ 17.85 2 T453X $ 194.00 No $ 59.00 CashDisc NetRevenue TotalDiscounts 596$ 136.80 $ 34.20 5% $ 65.90 $ $ 119.97 $ 9.03 177.00 $ 309.60 $ 77.40 36.15 $ 10.20 $ 421.29 $ $ 12.00 $ 108.30 $ 5.70 $ 1,131.30$ 125.70 FALSE $ 1.80 $ 0.20 FALSE $ 1.56 $ 0.44 $ 142.36 $ 7.49 FALSE 16.96 $ 0.89 $ 164.90 $ 29.10 FALSE $ 59.00 $ 10% 10% 284R 10% Cash Apple Pay Apple Pay Card Apple Pay Apple Pay Card Card 10% 10% 15% 5% 5% 15% 10% 10% 10% 10% 3T382P $ 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10%
