Question: How do I create use an if statement to perform the calculation? 2. In the Profit Analysis worksheet: a. Expenses costs include maintenance, cleaning, and

How do I create use an if statement to perform the calculation?

How do I create use an if statement to perform the calculation?

2. In the Profit Analysis worksheet: a. 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. b. 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. c. 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 d. 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. e. Adjust column width as needed to eliminate truncation after format adjustments

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 Accounting Questions!