n I16: 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 a Black or Stainless Steel, 120 V, Refrigerator 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.

AutoSave OM QUIZ 6 APPLIANCE DATA (1) Search (Alt+a) Mohammed Ayaan Moazzambussen Shaikh MA File Home Insert Page Layout Formulas Data Review View Help Comments Share 2 X = = = Autosum 2 Wrap Text Custom ITX Arial Narrow 11 AA BIURA AY o Fill Paste ===== PA be Conditional Format as Cell Formatting Table Styles Merge Center $% +388 Insert Delete Format Sort Find Filter Select Analyze Data Clear Unda Cupboard Font Alignment Number Styles Cells Editing Analysis G19 fx -INIRIGIT(A19,11-"2",C19,") C F 1 K L M N 0 P S 1st character Premium Standard R S G H 1 Alpha Numeric Product code Structure 2nd character 5th character Refrigerator S Stainless steel Slove w White Dishwasher B Black Mcrowave 6th character 1 2 120 VI 240 V D D M W Wuloven A B 1 Mohammed Aysan-103759213 2 2022-03-22 3 4 5 5 6 7 7 8 9 10 Top's Quality Appliances (Canada) 11 12 13 14 15 Product code Quantity 16 PD11B1 128 $ 17 PD4151 1,124 $ 18 PD41W1 1,144 $ 19 P04282 320 $ 20 PD4252 1,142 $ 21 PD4212 1,000 $ 22 PD62B1 565 $ 23 PD62B2 1,297 $ 24 DDR2 1 HES T Quiz 6 6 Reacy Accessibility: Good to go 24"C " Mostly cloudy 25.215 14,514 5.414 Price 1 2 3 4 5 6 6 7 1,127 1.819 1.296 1.440 1824 1394 1,446 1,312 1 TO 1,440 1,824 1394 1,312 FI 100% H ENG US 00 8:32 PM 2022-03-22