Excel #$1$ IF Statements

$$ Watch Linkedin Learning: IF and IFS statements

$$ Watch Linkedin Learning: AND, OR$,$ NOT

$$ In the YELLOW $$Mileage$$ column, create a formula to classify, based on mileage, if the car is HIGH $($greater than or equal to $90,000$ miles$),$ MID $($less than $90,000$ and greater than $30,000$ miles$),$ or LOW $($less than or equal to $30,000$ miles$).$

$$ In the YELLOW $$Automatic and FWD or AWD?$$ column, create a formula to indicate, based on transmission and drive type, if the car is Automatic and either front$-$wheel drive $($FWD$)$ or all$-$wheel drive $($AWD$).$ The formula should return $$Yes$($if the car is Automatic and FWD or AWD$)$ or $$No$($if the car is not Automatic and FWD or AWD$).$

$$ In the YELLOW $2006$ or newer and not Japanese?$$ column, create a formula to indicate, based on year and country of origin, if the car was made in $2006$ or later and not made in Japan. The formula should return $$Yes$($if the car was made in $2006$ or later and not made in Japan$)$ and $$No$($if the car is not made in $2006$ or later and$/$or not made in Japan$).$

$$ In the YELLOW $$Gross Profit Margin less than or equal to $10\%?$ column, create a formula to show which cars have a gross profit margin $(($Price $$ Cost$)/$ Price$)$ less than or equal to $10\%.$ The formula should return $$NEEDS REVIEW$$ for all cars with a profit margin less or equal to $10\%$ and blank otherwise.

$$ In the ORANGE cells, use formulas to answer the CHECK FIGURES questions.

$$ Submit your completed Excel file in DropBox.