In I16: 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 a White or Stainless Steel, 120 V, Microwave or Dishwasher insert the product Price, otherwise the cell should be blank. Copy the function down to the other cells in the column.In cell I14 use the appropriate function to calculate the total 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 stee 120 V S Standard S Stove W White 2 240 V D Dishwasher B Black M Microwave W Wall oven 10 Top's Quality Appliances (Canada) 11 12 13 14 15 Product code Quantity Price 1 2 3 4 5 6 7 16 PD41B 428 |$ 1,427 =IF( 17 PD41S 1.124 $ 1,819 18 PD41W1 .144 $ 1,296 19 PD4282 320 $ 440 20 PD4252 1.142 | $ 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 $ 1,668 26 PD62W1 224 $ 1,368 27 PD62W2 1,318 | $ 1,370 28 PD6481 1,120 S 1,552 29 PD6482 .297 $ 1,519 30 PD64$1 177 $ 1,886 31 PD6452 678 $ 1,857 32 PD64W1 571 $ 1,515 33 PD64W2 367 |$ 1,453 34 PM1181 483 $ 594 35 PM11$1 408 $ 305 36 PM11W1 639 S 621 37 PM1282 1,141 $ 509 38 PM1252 836 S 315 39 PM12W2 948 S 633 40 PM59B1 893 S B22 41 PM59B2 366 S 399 42 PM59S1 659 S 994 43 PM5952 1,327 $ 975 44 PM59W1 ,366 $ 718 45 PM59W2 434 $ 873 46 PM61B1 670 $ 783 47 PM61 B2 832 S 717 Quiz 6 + Edit 2 Accessibility: Good to go