In D16: Use the product code breakdown provided at the top of the worksheet as a guide and use appropriate nested functions to complete the following: If the product is Black insert the product Quantity, otherwise the cell should be blank. Copy the function down to the other cells in the column.In cell D14 use the appropriate function to calculate the totalquantity from the results. Format comma style, 0 decimal.

Alpha Numeric Product code Structure 1st character 2nd character 5th character 6th character P Premium R Refrigerator S Stainless steel 120 S Standard S Stove W White 2 240 V D Dishwasher B Black M Microwave W Wall oven 0 Top's Quality Appliances (Canada) 14 Product code Quantity Price 1 2 3 4 5 6 1 16 PD41B1 428 | $ 1,427 =IF( 17 PD4151 1.124 $ 1,819 18 PD41W1 ,144 $ 296 19 PD4282 320 S 1,440 20 PD4252 1.142 5 1,824 21 PD42W2 1,002 $ 1,394 22 PD62B1 595 | $ 1,446 23 PD6282 1.297 |$ 1,342 24 PD62S1 1.455 $ 1,796 25 PD6252 421 $ ,668 26 PD62W1 224 | $ ,368 27 PD62W2 1318 $ ,370 28 PD6481 1,120 $ 1,552 29 PD6482 1,297 $ 1,519 PD64S1 177 $ ,886 31 PD6452 678 $ 1,857 32 PD64W1 571 $ 1.515 33 PD64W2 367 $ 1,453 34 PM1181 483 $ 694 35 PM1151 408 |$ 805 36 PM11W1 639 $ 621 37 PM12B2 1,141 $ 609 38 PM1252 836 S 815 39 PM12W2 948 S 633 40 PM5981 893 $ 822 41 PM5982 366 S 699 42 PM59S1 659 $ 994 43 PM5952 1,327 $ 975 44 PM59W1 1,366 $ 718 45 PM59W2 434 $ 873 46 PM61B1 570 | $ 783 47 PM61 B2 832 | $ 717 Quiz 6 + Edit { Accessibility: Good to go