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 Rajin Shind Data & Share Comments A2 Copy ol 007.mladdproject data - Excel File Home Insert Page Layout Formulas Review View Developer Help Tell me what you want to do X 11. AA SEE. Wap Tet General BIV 0.A. F. 3 Merge & Contor. $. % 9 Conditional Format as call Formatting Table Styles we Insert De Format Sort & Find & Fher Select diting 119 Discount Rate 5.0% July Discount Category Percent Dairy Products Seafood 0.0% Meat/Poultry 75 Produce 100% 1 Category Name Last Name First Nam, Quantity Unit Price Product Shipped Date Freight Customer Name 2 Dairy Products Your Nar Your Nar 9 55.00 54.51 7/1/2014 1.23 Folk och f HB 3 Produce Your Nar Your Nan 21.05 20.56 7/1/2014 1.23 Folk och f HB 4 Seafood Your Nar Your Name 10 12.50 12.01 7/1/2014 1.23 Folk och f HB 5 Dairy Products Thomassolames 30 21.50 21.01 7/2/2014 1.21 Alfreds Futterkiste 6 Meat/Poultry Suyama Michael 5 19.00 13.50 7/3/2014 16.96 Furia Bacalhau e Frutos do Mar 7 Dairy Products Suyama Michael 35 55.00 54.51 7/3/2014 16.96 Furia Bacalhau e Frutos do Mar 8 Seafood Suyama Michael 35 15.00 14.51 7/3/2014 16.96 Furia Bacalhau e Frutos do Mar 9 Produce Your Nant Your Nant 6 10.00 8.40 7/4/2014 29.98 B's Meat/Poultry 10 Meat/Poultry Your Nar Your Name 15 18.00 17.51 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 55.00 54.51 7/4/2014 73.02 Old World Delicatessen 14 Meat Poultry Fuller Andrew 30 18.00 12.95 7/5/2014 31.43 Chop Suey Chinese 15 Meat/Poultry Fuller Andrew 40 123.79 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 19.45 18.96 7/5/2014 31.43 Chop Suey Chinese 18 Seafood Andrew 48 49.90 48.81 7/5/2014 31.43 Chopsuey Chinese 19 Seafood Levering lanet 40 62.50 48.75 7/5/2014 212.98 QUICK-Stop 20 Produce Leverling lanet 10 14.00 13.5: 7/5/2014 212.98 QUICK-Stop 21 Seafood Levering lanet 16 9.50 9.01 7/5/2014 212.98 QUICK-Stop Your Name Profit Sheet1 Ready Body Setings Type your formulas here: =IFSI