80.2K

Verified Solution

Link Copied!

in H16 Use the product code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following M te product is a Standard, White or Black, Dishwasher insert the product Price, otherwise the cell should be blank. Copy the function down to the other cells in the column. In cell 14 use the appropriate function to calculate the total from the results. Format comma stys, o declimat A E N- 1st character P Premium S Standard G H Alpha Numeric Product code Structure 2nd character 5th character R Refrigerator S Stainless std S W White D B Black M Microwave w Wall oven 3 4 5 6 7 8 9 6th character 1 120 V 2 240 V 10 Top's Quality Appliances (Canada) 11 46,284 16,097 2 14,388 1 3 4 5 7 1.124 1.142 12 13 14 15 Product code 16 PD4181 17 PD4151 18 PD41W1 19 P04282 20 PO4252 21 PO4W2 22 PO6281 23 PD6282 24 P06251 25 P06252 26 PD621 27 PO622 28 PD5481 29 PO6482 30 PD6451 31 PO5452 32 POW1 33 PD54W2 34 PM1191 35 PM1151 Quantity 4285 1.1245 1.1448 3205 1.142 $ 1,0025 595$ 1,2975 1.456 S 421 $ 2245 1318 1.120$ 1,297$ 1775 678$ 571 $ 367 4833 408 15 Price 1,427 1.819 1.200 1,440 1.824 1,394 1,446 1,342 1,798 1,668 1,368 1,370 1.552 1,519 1.686 1,857 1,515 1.456 421 177 678 1,453 694 805 408 Quiz 6 + Ready

Answer & Explanation Solved by verified expert

See Answer