In E$16$: 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 Stove insert the product Price, otherwise the cell should be blank. Copy the function down to the other cells in the column.

In cell E$14$ use the appropriate function to calculate the total from the results. Format comma style, $0$ decimal.

In F$16$: 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 White, $240$ V$,$ Wall Oven insert the product Quantity, otherwise the cell should be blank. Copy the function down to the other cells in the column.

In cell F$14$ use the appropriate function to calculate the total from the results. Format comma style, $0$ decimal.

In G$16$: 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 Premium, Stainless Steel, $240$ V$,$ Wall Oven insert the product Price, otherwise the cell should be blank. Copy the function down to the other cells in the column.

In cell G$14$ use the appropriate function to calculate the total from the results. Format comma style, $0$ decimal.

In H$16$: 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 Premium, Black, Dishwasher or Stove insert the product Quantity, otherwise the cell should be blank. Copy the function down to the other cells in the column.

In cell H$14$ use the appropriate function to calculate the total from the results. Format comma style, $0$ decimal.

In I$16$: 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 White or Black, Stove or Wall Oven insert the product Quantity, otherwise the cell should be blank. Copy the function down to the other cells in the column.

In cell I$14$ use the appropriate function to calculate the total from the results. Format comma style, $0$ decimal.

In J$16$: 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 Black or White, Wall Oven or Refrigerator, $240$ V or Standard insert the product Quantity, otherwise the cell should be blank. Copy the function down to the other cells in the column.

In cell J$14$ use the appropriate function to calculate the total from the results. Format comma style, $0$ decimal.