Need Formulas shown for excel

E. Y= fx 100% Q- Search in Sheet A Home Layout Tables Charts Data Review Developer SmartArt Formulas External Data Sources Sort & Filter Analysis Tools , RE Text to Columns Group & Outline P Show Detail + TO Group Ungroup VE Hide Detail Validate Remove Duplicates K Sort Filter Pivot Table What if Solver Refresh Text Database HTML FileMaker Consolidate C18 ; X fx A B C D G H 1 2 If I order up to X units of a product, I pay $Y per unit. The price applies to the entire order, not graduated through the breaks. 3 4 Write an IF statement that expresses the Purchase Cost as a function of the number of units purchased. 5 6 Remember, calculate the Purchase Cost, not just the Price. 7 (10 Points) 8 9 10 Qty Break Point Price 11 Tier 1 15 $ 5.25 O 10 points possible 12 Tier 2 50 $ 4.85 13 Tier 3 200 $ 4.15 14 Tier 4 >200 $ 3.85 15 16 17 QUANTITY PRICE 18 5 19 PAY ATTENTION! This MUST be an IF 55 20 145 statement, and I'm looking for the total 21 230 purchase cost, not just the price per unit! 22 23 24 25 IF Statements-Extra Credit VLOOKUP & Cond Format Exra Credit Two-Input Table Regression Cost-Benefit Analysis Solver Hyperlinks Balance Sheet + 200 RRRR BBB WACC Sum-0 Normal View