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
Get step-by-step solutions from verified subject matter experts
