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

If the product isBlack and 120 Vinsert the productPrice, otherwise the cell should be blank. Copy the function down to the other cells in the column.

In cellE14use the appropriate function to calculate thetotalfrom the results.Format comma style, 0 decimal.

A B C D E F G H K L Product code structure Ist character 2nd character 5th character 6th character P Premium R Refrigerator S Stainless ste 120 V 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 2 3 4 5 6 7 16 PD41B1 128 $ ,427 17 PD41S1 1, 124 $ 1,819 18 PD41W1 1, 144 $ 1,296 19 PD42B2 320 $ 1,440 20 PD42S2 1, 142 $ 1.824 21 PD42W2 1,002 $ ,394 22 PD62B1 595 $ 1,446 23 PD62B2 1,297 $ 1,342 24 PD62S ,455 $ 796 25 PD62S2 421 $ 1,668 26 PD62W1 224 $ 1,368 27 PD62W2 1,318 $ 1,370 28 PD6481 1, 120 $ 1,552 29 PD64B2 ,297 $ 1,519 30 PD64S 177 $ 1,886 31 PD6452 678 $ 1,857 32 PD64W1 571 $ 1,515 33 PD64W2 367 $ 1.453 34 PM11B1 483 | $ 694 35 PM11S 108 $ 805 Sheet1 +