(Solved): In 014: Use the VIN # code breakdown provided at the top of the worksheet as a guide to create app ...

In 014: 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 Red or White and the Sales Price is more than \( \$ 25,000 \) insert the number 1 , otherwise the cell should be blank. Copy the function down to the other cells in the column. In cell \( \mathbf{0 1 3} \) use the appropriate function to count the number of results. Format comma style, O 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 2014 or 2015 and the MSRP is less than \( \$ 23,500 \) insert the number 1 , otherwise the cell should be blank. Copy the function down to the other cells in the column. In cell \( \mathbf{P} 13 \) use the appropriate function to count the number of results. Format comma style, 0 decimal.