I need to figure out what Logical test to use for the IF function that is needed for the discounts. I think I have everything else right

73% 0 Excel File Edit View Insert Format Format Tools Data Window Help ASU Home Insert Draw Page Layout Formulas Data Review View Ex31F&PMTFunctions Wed Sep 2 3:58 PM Tyler E Q- Search Sheet S+ Share A Insert Delete Sort & Find & Format Filter Select - A- A - General Calibri (Body) - 11 BIU U- 49. Qi $ A- = 008 $ - % Paste Conditional Format Formatting as Table Cell Styles G9 fx =IF($D$5*E9,$D$5* E9,0) A B D E F H 1 J K L M N o P Q R S S IF & PMT function Exercise 3a 1 2 Use the following to create an IF statement that determines the discount amount in column G. Use absolutecell addresses so that it can be copied from G9 all the way through G15. Discount: 10% RuleDiscount applicable if customer has a coupon. Total Customer Aaron Dixie Michael Logan Fel Matt Josh Price $ 12.95 $15.78 $11.49 S S 999 $16.95 $ 1295 $11.49 anty 12 $ 89 $ 125 $ 2000 5 141 S 250 $ 50 $ Ext-Price 155.40 1,404,42 1,436,25 19,980.00 2,389.95 3,237.50 574.50 Coupon Yes No Yes No No Yes No Discount 15.54 140.442 143,625 1998 238.995 323.75 57.45 4 5 IF Function: 6 7 B 9 9 10 11 12 13 14 15 16 17 18 PMT Function: 19 20 21 22 23 24 25 26 27 Loan Shark loan-weekly payments for a year - unless you miss a paymenti) Amount Years Payments/ Annual interest $ 1.000 1 1 52 119.50% #Payments: 52 Interest/Period: 0.022980769 Payment: ($33.15) Use the PMT function to calculate the weekly payment in cell F23. Change some of the input values amount years, etc.) to see how the payment changes. 28 29 30 31 Log Documentation Demo Demo2 Exercise 3a Exercise 3b + Ready B + 100%