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

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. Use the relevant cell reference when you write your formula.

Enter your Function here:

B- Can you use the SWITCH formula to solve the problem?

If yes, type your formula here:

To complete this assignment answer the following

AutoSave On H2 Copy of e07_ml_addproject_data - Excel Rajaa Shindi File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what you want to do Share Comments LO === General TH Calibri - 11-AA BIU - - A. 2 Wrap Text E Merge & Center - WE 28 O Paste LG $ - % ,00 Insert Delete Format Conditional Format as Formatting Table Styles Styles Sort & Find & Filter - Select - Editing Clipboard Font Alignment Number Cells L19 fic K N Discount Rate M July Discount Category Percent Dairy Products Seafood 0.0% Meat/Poultry 7.5% Produce 10.0% 5.0% A B C D E F H 1 Category Name Last Name First Name Quantity Unit Price Product Shipped Date Freight Customer Name 2 Dairy Products Your_Narr Your_Narr 9 55.00 54.51 7/1/2014 1.23 Folk och f HB 3 Produce Your Nar Your Nam 40 21.05 20.56 7/1/2014 1.23 Folk och f HB 4 Seafood Your_Narr Your_Nam 10 12.50 12.01 7/1/2014 12:24 2. 1.23 Folk och f HB 5 Dairy Products Thomasso James 30 21.50 21.01 21.01 7/2/2014 1.21 Alfreds Futterkiste 6 Meat/Poultry Suyama Michael 5 19.00 13.50 7/3/2014 2012 2014 16.96 Furia Bacalhau e Frutos do Mar Dairy Products Suyama Michael 10. Fant becama 35 55.00 54,51 7/3/2014 2010 16.96 Furia Bacalhau e Frutos do Mar samed 8 Seafood Suyama Michael 35 15.00 14.51 7/3/2014 w 16.96 Furia Bacalhau e Frutos do Mar 9 Produce Your Nar Your Narr 6 10.00 8.40 7/4/2014 29.98 B's Meat/Poultry 10 Meat/Poultry we Your_Nar Your_Nam 15 18.00 17.511 7/4/2014 29.98 B's Meat/Poultry 11 Seafood Callahan Laura 20 17.45 16.99 7/4/2014 73.02 Old World Delicatessen 12 Meat/Poultry Callahan Laura 24 46.00 45.51 7/4/2014 73.02 Old World Delicatessen 13 Dairy Products Callahan Laura 8 8 55.000 54.51 7/4/2014 73.02 Old World Delicatessen Fuller Andrew 20 30 18.00 12.95 7/5/2014 31.43 Chop-suey Chinese 15 Meat/Poultry Andrew 40 122 za 82.50 7/5/2014 31.43 Chop suey Chinese 16 Meat/Poultry Fuller Andrew 40 46.00 45.51 7/5/2014 31.43 Chop-suey Chinese 17 Produce Fuller Andrew 24 18.96 7/5/2014 31.43 Chop-suey Chinese 18 Seafood Fuller Andrew 48 49.30 48,81 7/5/2014 31.43 Chop-suey Chinese 19 Seafood Leverling Janet 40 62.50 48.75 7/5/2014 212.98 QUICK-Stop 20 Produce Leverling Janet 10 14.00 13.51 7/5/2014 212.98 QUICK-Stop 21 Seafood Leverling Janet 16 9.50 9.01 7/5/2014 212.98 QUICK-Stop Lin Your_Name_Profit Sheet1 + Ready 14 Meat/Poultry Fuller 19.45 TIINA > TE Display Settings E 1 + 10096

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...

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....

Deposit Rules for Glo-Brite Paint Company The FICA taxes and FIT taxes must be deposited on or before the 15th of the month following the month in w Federal taxes were withheld. Since Glo-Brite is a...

Please help! (I need all answered by wednesday!) Thank you very very much!! Name: ___________________________________ FIN 459 - INTRODUCTION TO DERIVATIVES, SPRING 2016 INSTRUCTOR: TOM BARKLEY...

Task 1 (45 marks). The following Bloomberg screen presents BHP Billiton fixed-income security for you to evalute. In the first task of your assignment, answer the following questions. Figure 1....

On December 31, 2015, Martin Corp invested in Marlins 5-year, $200,000 bond with a 5% interest rate for $191,575. The bond pays semiannual interest on June 30th and December 31st. The fair values of...

2. Task 2: Write a Java Servlets program for calculating the total number of hits on a web page designed by you. The web page should contain at least one title, one label and one output tag which...

Do you know how to complete question four? Name 4) What are the Average Annual Rates of Return of each investment? Remember on Jan 1 of Year 1, the value of the investment is the initial cost. You...

Jake Johnson is a young single professional living in Charlotte, North Carolina. At age 24, he has been working for six months at his new job as a junior electrical engineer at a local utilities...

Assume that the contract had simply stated that Pezza was obligated to excavate and remove 50,000 to 60,000 cubic yards of rock and gravel. Pezza then discovered the ledge, and refused to continue...

Jupiter Investments acquired $40,000 Carlisle Corp., 9% bonds at par value on September 1, 2012. The bonds pay interest on September 1 and March 1. On March 1, 2013, Jupiter sold $40,000 par value...

CashTransactionDebit amountTransactionCredit amount ( 1 ) 5 0 , 0 0 0 ( 2 ) 4 , 0 0 0 ( 7 ) 1 3 , 1 0 0 ( 3 ) 1 0 , 0 0 0 ( 4 ) 6 , 1 7 5 ( 6 ) 6 , 0 0 0 ( 9 ) 1 , 5 0 0 EquipmentTransactionDebit...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...