In M14: Use the VIN # code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:

If the vehicle has a Gas engine with a White or Metallic White colour insert the Sales Price, otherwise the cell should be blank. Copy the function down to the other cells in the column.

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

In N14: Use the VIN # code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:

If the vehicle was sold by sales rep Mark in 2016 or 2017 insert the Sales Price, otherwise the cell should be blank. Copy the function down to the other cells in the column.

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

In O14: Use the VIN # code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:

If the vehicle model year is 2013 or 2014 and the MSRP is more than $21,000 insert the number 1, otherwise the cell should be blank. Copy the function down to the other cells in the column.

In cell O13 use the appropriate function to count the number of results. Format comma style, 0 decimal.

In P14: Use the VIN # code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:

If the vehicle model year is 2012 or 2013 and the MSRP is less than $19,500 insert the number 1, otherwise the cell should be blank. Copy the function down to the other cells in the column.

In cell P13 use the appropriate function to count the number of results. Format comma style, 0 decimal.

In Q14: Use the VIN # code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:

If the vehicle is a Toyota Camry or Toyota Corolla and was sold in 2014 or 2015 and has a Gas 1800 CC engine insert the number 1, otherwise the cell should be blank. Copy the function down to the other cells in the column.

In cell Q13 use the appropriate function to count the number of results. Format comma style, 0 decimal.

In R14: Use the VIN # code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:

If the vehicle is Model Year 2013 or 2014 and is assembled in Toyota City, Dusseldorf or Cambridge insert the number 1, otherwise the cell should be blank. Copy the function down to the other cells in the column.

In cell R13 use the appropriate function to count the number of results. Format comma style, 0 decimal.