In E16: Use the product code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:

If the product is a Standard Dishwasher insert the product Quantity, otherwise the cell should be blank. Copy the function down to the other cells in the column.In cell E14 use the appropriate function to calculate the total from the results. Format comma style, 0 decimal.

Chrome File Edit View History Bookmarks Profiles Tab Window Help Thu Mar 24 2:16 PM AutoSave OFF MSC. QUIZ & APPLIANCE DATA.xlsx Home Insert Draw Page Layout Formulas Data Review View Tell me Share W Comments Default Ruler Formula Bar Split Zoom 100% H KAAP Exit New = Options Normal Page Break Page Custom Preview Layout Views Gridlines Headings DEB % Zoom to 100% Zoom to Selection New Window Arrange Freeze Freeze Freeze First All Pancs Tap Row Column Hide Unhide windows Unic Switch View Record Us Relative Macros Macro References D E J K M N 0 P Q R S T U 1st character P Premium S Standard E16 x fx A B C 1 1 2 2 3 4 5 6 7 7 g g 10 Top's Quality Appliances (Canada) 11 12 13 14 F F G H 1 Alpha Numeric Product code Structure 2nd character 5th character R Refrigerator s Slness ste S S Slove W While D Dasher B Black M Wirceave W Wal oven 6th character 1 120 V 2 240 V 86,885 Price 1 1 2 3 4 S 6 7 15 Product code 16 P1241 17 PD451 18 PD4 W 19 P04282 20 PD1252 21 PD4212 22 PD5201 2 PD6202 24 P1081 25 PD5252 2E PDB2W 27 PDE2W2 22 PD8421 29 PD8482 30 PD5451 31 PD6492 3 PAW 33 PD542 34 PV 1191 36 PV 1151 Quantity 428$ 1,1215 1.14 320$ 1,1425 1.0112 595$ 1,2975 1.455$ 1215 2243 1318$ 1,1205 1.297 $ 1775 6783 571 $ 3675 480S 408$ . + 1.427 1.819 1.29% 1440 1.824 1.394 1.446 1.342 1.795 1.663 1.263 1370 1.552 1.619 1.888 1.857 1.515 1.153 494 ans w Quiz 6 Ready + 100% 3 SE 24 a O Nav ili A 0