n D16: 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 Premium 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 total quantity from the results. Format comma style, 0 decimal.

What is the formula ?

 

1 2 3 4 5 6 7 8 9 A B C D E F G H J K L Product code structure 1st character 2nd character 5th character 6th character P Premium R Refrigerator S Stainless ste 1 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 PD41B1 428 $ 1,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 $ 1,394 22 PD62B1 595 $ 1,446 23 PD62B2 1,297 $ 1,342 24 PD62S1 1,455 $ 1,796 25 PD62S2 421 $ 1,668 26 PD62W1 224 $ 1,368 27 PD62W2 1,318 $ 1,370 28 PD64B1 1,120 $ 1,552 29 PD64B2 1,297 $ 1,519 30 PD64S1 177 $ 1,886 31 PD64S2 678 $ 1,857 32 PD64W1 571 $ 1,515 33 PD64W2 367 $ 1,453 34 PM11B1 483 $ 694 35 PM11S1 408 $ 805 m Sheet1 + Enter