Question: I need help making and IF statement: First, use the IF statement to determine the single vehicle Expenses (by comparing the values in the CarClass

I need help making and IF statement:

First, use the "IF" statement to determine the single vehicle Expenses (by comparing the values in the "CarClass" column and second, edit the cell contents to multiply it by the NumCars so that the Expenses value represents the total Expenses costs for the Number of Cars (NumCars) rented that row.Expenses = Numcars * Expense per Car c. Use the absolute cell address for the numerical Expenses value for ONE vehicle which should then be multiplied by the number of cars in each row.

Hybrid car: $100

Non-hybrid car: $50

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!