eo e 11 89% 1 1 :45 AM Expert Q&A Remaining Remaining Alcare offers a 3 2% (ACDscount) discourt on lems when more than three units are ordered at one time in column F, use a nested IF and AND formula and the named ranges (Supplier, ACDiscount, UnitPrice, NumToOrder) to calculate the discount for each of the supplies listed. It no discount ts given, place a zero (0). Format the numbers in the column to display two digits past the decimal point Note: Use all lowercase letters when typing the formula Check Answer Clinic Standard Costs-Excel Roger LattaX i Home Insert Draw Page Layout Data Review View Help Tell me what you want to do fs 15 Insert AutoSum Recenthy Financial Logical Test Date & Lookup & Math & More Nam M IE , ea DefineNanne , , Define Name ,S-Trace Precedents Show Fermulas- a Calculate Now Calculate Now % use in Formula Trace Dependents t Enor Checking Create from Selection Remove Armows Evaluate Fermula Watch Cakcullation Calculate Sheet Time. Reference, Tr 9. Functions. Manager Window Optians Used Fundion Libeary Defined Name ormula Auditing North Shore Medical Clinic Vendor Discount Evaluation Number of Units to be OrderedSupplier 3 Item Unit Unit Price Discount 4 Sterile powder-free synthetic gloves, size Medium per 100 Sterile powder-free synthetic gloves, size Large per 100 per 100 Sterile powrder-free latex gloves, size Medium per 100 per 100 Sterile powder-free vinyl gloves, size Medium per 100 per 100 per 50 35.95 5.95 16-25 16.25 16.25 11.50 11 50 5.61 7.90 AC sterile powder-free latex gloves, size 5mall e Stenle powder-free latex gloves, size Large Sterile powder-free viny gloves, size Large Disposable earloop mask AC BC Bc patient gown per dozen