Question: I keep receiving an error message in excel when i used the if statement below. =IF([@CarClass]=Hybrid,[@NumCars ]]*$N$1,[@NumCars ]]*$N$2) What is the proper if statement? what
I keep receiving an error message in excel when i used the if statement below.
=IF([@CarClass]="Hybrid",[@NumCars ]]*$N$1,[@NumCars ]]*$N$2)
What is the proper if statement? what am i doing wrong?
The directions are below.
Expenses costs include maintenance, cleaning, and administrative expenses associated for a car rental. The Expenses for one rental transaction will be determined from the values specified in the worksheet. DO NOT enter the values in this column on a cell by cell basis. a. In the first cell directly under the Expenses label, calculate the total Expenses that corresponds to the number of cars rented IN THAT ROW (NumCars) using an "IF" statement as part of the formula to determine the value of Expenses for one vehicle.b. 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. d. Adjust column width as needed to eliminate truncation after format adjustments. Note: the use of absolute cell addresses allows those Expenses values to be changed and then by recalculation, update the entire Excel table.It can be helpful to double-check a hybrid and a nonhybrid row with a calculator for calculation accuracy.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
