1. Please help. I'm not understanding how to do this IF statement stuff. I need the answers. Please provide how you got to your answers.
2. In the Profit Analysis worksheet:
   1. Expenses costs include maintenance, cleaning, and administrative expenses associated for a Bike 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.
   2. In the first cell directly under the Expenses label, calculate the total Expenses that correspond to the number of Bikes rented IN THAT ROW (NumBikes) using an "IF" statement as part of the formula to determine the value of Expenses for one bike.
   3. First, use the "IF" statement to determine the single bike Expenses (by comparing the values in the "BikeType" column) and second, edit the cell contents to multiply it by the NumBikes so that the Expenses value represents the total Expenses costs for the Number of Bikes (NumBikes) rented that row. Expenses = NumBikes * Expense per Bike
   4. Use the absolute cell address for the numerical Expenses value for ONE bike which should then be multiplied by the number of Bikes in each row.
   5. Adjust column width as needed to eliminate truncation after format adjustments.

1. In the Profit Analysis Worksheet:
   1. In the first cell directly under the Profit label, calculate total profit by subtracting Expenses from revenue (should be a positive number). (Revenue Expenses). Then repeat the formula for each row below.
   2. In the first cell directly under the ProfitperBike label, divide Profit by NumBikes (Profit/NumBikes). Then repeat the formula for each row below.
   3. Adjust column widths as needed to eliminate truncation after formatting.
   4. Verifying the accuracy of a few cells calculation with a calculator can be helpful.