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

If the product is aMicrowaveinsert the productPrice, otherwise the cell should be blank. Copy the function down to the other cells in the column.

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

Product code structure Ist character 2nd character 5th character 6th character P Premium R Refrigerator S Stainless s 1 120 V S Standard S Stove W White 2 240 V D Dishwasher B Black M Microwave W Wall oven Top's Quality Appliances, Canada Product code Quantity Price PD4181 428 $ 1,427 PD4151 1,124 1,819 P041W1 1.144 $ 1,296 PO4282 320 $ 1,440 PD4252 1,142 1,824 PO42W2 1,002 $ 1,394 PD6281 595 1,446 PD6282 1,297 $ 1,342 PD6251 1,455 1,796 PO6252 421 $ 1,668 PD62W1 224 $ 1,368