Question: 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
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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
