Answer Happy

4 points In J16: 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 Stainless Steel or White, Dishwasher or Refrigerator, 120 V or Standard insert the product Quantity, otherwise the cell should be blank. Copy the function down to the other cells in the column. In cell J14 use the appropriate function to calculate the total from the results. Format comma style. O decimal.
1 117 3 4 5 6 7 8 B 13 14 X Cut Copy Clipboard 15 16 P04181 17 PD4181 18 PD41W1 19 PD4282 20 PD4282 21 PD42W2 22 P06261 23 P06282 24 PD6281 Ready Format Painter 25 PD6282 25 P062W1 27 P082W2 28 P06481 29 P06482 30 P064ST Product code A 12 X 10 Top's Quality Appliances (Canada) 11 12 Arial Narrow B BIU- M Quiz 6 Accessibility: Good to go Quantity fr 428 S 1,124 S 1.144 S 320 $ 1,142 S 1,002 S 595 $ 1,297 S 1,455 $ 421 S 224 $ 1,318 S 1.120 $ 1,297 S 177 $ C - 12 HE Fort Price 1,824 1.394 1,446 1,342 1.795 1,668 1,368 1,370 25 1.552 1,519 1.886 D P S AA 1 1,427 1,819 1,296 1,144 1.440 43,592 fat character Premium Standard 1,002 A 224 1.318 E 14.514 12 P F R S D M W 3 Alignment Wrap Text Merge & Center G H Alpha Numeric Product code Structure 5th character 2nd character Remigerator Slove Dehwanhor Microwave Wall oven 4 8 W B General 5-% S 1 Number Stainless stee White Black 6 43 J 1 2 7 E Conditional Format as Cell Formatting Table Style Styles K 6th character 120 V 240 V