Question: A- Write a nested if function (IFS) to calculate the discount rate for each shipment using the discount rates provided in the range L2:M6. Use

A- Write a nested if function (IFS) to calculate

A- Write a nested if function (IFS) to calculate the discount rate for each shipment using the discount rates provided in the range L2:M6. Use the relevant cell reference when you write your formula. Enter your Function here: Rosa Shind Copy at et merci de Excel Review View Developer Help Tell me what you want to do Home Page Layout Form Duta W! Age Care Conditional Format Formatting Die Forma Sort & She Discount Rate Maly Decount Category Dairy Products Seafood 0.00 Meat Poetry 7.5% Produce 10.0 55.00 1 Category Name Last Name First Nam.Quantity Unit Price Product Shipped Date Freight Customer Name Dairy Products Your Man Your Nam 9 SS. 545 7/1/2014 1.3 Folk och HB Prode Your Man Your Mar ag 21.05 20:56 7/1/2014 1.2. Folk och HB 4 Seafood Your_Nan Your_Nar 10 12.50 12.01 2/1/2014 1.23 Folk och HD 5 Dairy Products Thomassames 20 2150 21.01 72/2014 123 Alfreds Putterste 6 Meat/Poultry Suyama Michael 5 19.00 13.50 2/1/2014 1696 Puri Bacalhau e Frutos de Mar 7 Dairy Products Suyama Michael 35 5451 2/2014 16.96 Furia Bacalhau e Frutos de Mar 3 Seafood Suyama Michael 35 15.00 1451 2/3/2014 16.96 Furia Bacalhau e Frutos de Mar 9 Produce Your Nar Your Name 6 10.00 R. 2/4/2014 29.980's Meat Poultry 10 Mat/Poultry Your Nar Your Nam 15 18.00 12.50 7/4/2014 28.98 Meat Poultry 11 Seafood Callahan Laura 20 12.45 16.99 7/4/2014 73.02 on World Delicatessen 12 Mat/Petry Callahan Laure 24 46.00 45.53 7/4/2014 73.02 Old World Delicatessen 13 Dairy Products Callahan Laura 55.00 54.5: W 2014 73.00 Old World Delicatessen 14 Meat/Petry Ful Andrew 18.00 2/2014 31.4 Chapsuey Chinese 15 Meat/Petry Andrew ad 123 2.50 7/2014 31.49 Chap-wey Chinese 16 Meat/Petry Andrew es 45.00 7/2014 31.49 Chapsuey Chinese 17 Produce Andrew 24 as 19 2/1/2014 31. Chassuy Chinese 18 Seafood Andrew 49 488 7/2014 31.49 Chapsuey Chinese 19 Seafood 25 4875 2/2014 212.99 QUICK-Stop 20 Produce Levering 10 14.00 13:51 2/9/2014 212.90 QUICK Stop 21 Seafood 10 9.50 9.01 2/2014 212 00 QUICK Stop Your Name Profit Show D B- Can you use the SWITCH formula to solve the problem? If yes, type your formula here

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

To complete this assignment answer the following questions. A- Write a nested if function ( IFS) to calculate the discount rate for each shipment using the discount rates provided in the range L2:M6...

Excel 2019 Proje der - Instructions Points Step Instructions Possible 16 You are ready to start completing the loan amortization table. 5 Display the Loan worksheet. In cell B8, type a reference...

Q1-Explain how the EBIT Chart works (inputs determining the outputs-the two lines on the chart Case Leahy Bread Company (LBC) in Cohen Finance Workbook, page 111( a 'caselette') SEE THE IS/BS MODEL &...

Excel Chapter 7-Real Estate Exp19_Excel_Cho7_Cap_Real_Estate Project Description: You are the office manager for a real estate company in northern Utah County. You tracked real estate listings,...

Please solve this Excel spreadsheet using the directions! Thank you so much! Directions: Excel Spreadsheet: The manager of Paco's Dog Treats, Inc. imported inventory data. This data must be cleansed....

Steps to Perform: Step Instructions Points Possible Start Excel. Download and open the file named Exp19 Excel_Ch07_Cap_RealEstate.xlsx. Grader has automatically added your last name to the beginning...

PLEASE ANSWER THESE QUESTIONS IN EXCEL FORMULAS!!!! (Give me answers for yellow and grey boxes in the sheet. I don't need numbers. I need formulas to type in!!) The sheet provided above was provided...

I need answers for 7-11. Grader - Instructions Excel 2019 Project Step Instructions Points Possible 6 1.8 Another rewards program that Aleeta is considering includes a way for non-club members to...

Accounts receivable turnover, inventory turnover, and net margin Selected data from Warren Company follow. Required Compute the following: a. The accounts receivable turnover for 2011. b. The...

What is the value of an investment that pays $25,000 every other year forever, if the first payment occurs one year from today and the discount rate is 9 percent compounded daily? What is the value...

On the basis of your analysis, what actions should John Malone take to improve MOPs profitability? Include some suggestions for managing customer profitability.

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...