Question: In cell J6, enter a formula to determine the total cost with gas if the customer chose that option as indicated in column I. Use

In cell J6, enter a formula to determine the total cost with gas if the customer chose that option as indicated in column I. Use the name range for cell B44 in this formula.

I tried the formula=IF(I6="n",H6,IF(I6="y",(H6*GasCost))). But when it gets to an answer with y i end up with ####

Express Car Rental Rentals Initiated in Week Starting 4/5/2015 Created by Jason Easton Auto Type Green Collection Compact/Midsize Compact/Midsize Green Collection Fullsize/Standard SUV/Minivan SUV/Minivan Fullsize/Standard Green Collection Compact/Midsize Fullsize/Standard Fullsize/Standard Fullsize/Standard SUV/Minivan SUV/Minivan Green Collection Green Collection Green Collection Fullsize/Standard SUV/Minivan SUV/Minivan Fullsize/Standard Fullsize/Standard Compact/Midsize Compact/Midsize SUV/Minivan Green Collection Auto Id Date Rented 988 4/5/2015 275 4/5/2015 277 4/9/2015 990 4/5/2015 350 4/5/2015 550 4/5/2015 551 4/7/2015 352 4/7/2015 989 4/6/2015 275 4/11/2015 355 4/9/2015 356 4/6/2015 350 4/9/2015 553 4/8/2015 550 4/11/2015 988 4/9/2015 989 4/10/2015 990 4/7/2015 356 4/9/2015 551 4/11/2015 554 4/7/2015 352 4/10/2015 356 4/11/2015 276 4/11/2015 277 4/11/2015 554 4/10/2015 990 4/11/2015 Rental Rates Green Collection Compact/Midsize Fullsize/Standard SUV/Minivan $49.99 $76.49 $84.99 $104.99 Discount for Express Miles or Rewards Cost to Fill Tank 20% $65.00 Date Returned/or Expected Return #Days Rented 4/8/2015 3 4/10/2015 5 4/10/2015 1 4/6/2015 1 4/8/2015 3 4/9/2015 4 4/10/2015 3 4/9/2015 2 4/9/2015 3 4/18/2015 7 4/16/2015 7 4/8/2015 2 4/13/2015 4 4/14/2015 6 4/17/2015 6 4/15/2015 6 4/16/2015 6 4/10/2015 3 4/10/2015 1 4/15/2015 4 4/9/2015 2 4/11/2015 1 4/17/2015 6 4/14/2015 3 4/15/2015 4 4/12/2015 2 4/18/2015 7 Payment Method Credit Card COD Express Miles Credit Card Credit Card Rewards Credit Card Credit Card Credit Card COD Credit Card Credit Card Rewards Express Miles COD Credit Card Express Miles Credit Card Rewards Express Miles Express Miles Credit Card Express Miles Credit Card Rewards COD Express Miles Median Rental Length Number of Rentals /2015 Daily Rate $49.99 $76.49 $76.49 $49.99 $84.99 $104.99 $104.99 $84.99 $49.99 $76.49 $84.99 $84.99 $84.99 $104.99 $104.99 $49.99 $49.99 $49.99 $84.99 $104.99 $104.99 $84.99 $84.99 $76.49 $76.49 $104.99 $49.99 Total before Options Gas Option n n n n y y n y n n y y y y y n n n n y y y y n n y n Total

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

During jury selection at his state court trial for aggravated murder and related offenses, the state used all 6 of their peremptory challenges to strike the only 6 black individuals from the jury....

In cell J6, enter a formula to determine the total cost with gas if the customer chose that option as indicated in column I. Use the name range for cell B44 in this formula. Note:*** what is already...

In cell Q6, enter a formula to determine the average total cost based on the payment method type in cell P6. Use absolute references where necessary to copy the formula through cell Q9. Share fx *2 A...

need help for both those questions 8 In cell G6, use an appropriate VLOOKUP function to retrieve the daily rate from the named range Rates for the product in column A. The function should look for an...

In the cell H6 enter a formula that determines the total cost based on the number of days the vehicle was rented and the discount indicated in the cell B42. if the payment method was Express miles or...

Assign a niamed range of Discount to cell B 4 2 and a named range of GasCost to cell B 4 4 . In cell H 6 , enter a formula to determine any discount that should be applied. If the payment method was...

PLEASE ANSWER QUESTION 6 AND 7. Miles or Rewards lo RSS ESSE Ees ZZZ>>>>ZZZ Enable Editing PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to...

1. In cell H6, enter a formula to determine any discount that should be applied. If the payment method in column F was Rewards, the customer should receive the discount shown in B42, otherwise the...

Cross State Trucking Brian Eagleton is a dispatch manager at Cross State Trucking, a major Case folder included with you 2. Change the name of the Sheet worksheet using Travel Log as the name, and...

Financial Plan for a Lawn Care Business Running your own lawn care business can be an excellent way to make money over the summer while on break from college. It can also be a way to supplement your...

Open the file named PR2 Data from the Data Files and then Save As PR2 Lawn Care . Click cell C5 in the Annual Plan worksheet. Write a formula that calculates the average price per lawn cut. Do not...

2. Write down the difference between AC and DC circuits.

Assume that you are planning to purchase a 50-inch plasma television. In groups of three or four, determine the lowest cost for the television, considering the available alternatives and the...

Optional insurance plans, such as cell phone and pet insurance, can be useful for people who have a history of frequent visits to repair shops or vets. For folks who do not often need these services,...

The following information relates to Gretan Ltd and Hutey Ltd. Both companies manufacture and sell calculators. Gretan Ltd Hutey Ltd Sales in units per year 20,000 20,000 Selling Price per unit Rs500...

Define a function that takes two integers x and k as parameters. The function should divide x into k (mostly) equal integers and combine each of these integers into a list. The function should return...

Webster Company produces 20,000 units of product A, 15,000 units of product B, and 18,500 units of product C from the same manufacturing process at a cost of $425,000. A and B are joint products, and...

Translate the following into Spanish. 1 Another hour 2 Many jackets 3 Whose watch? 4 Marta's cousin 5 Each truth 6 The students 7 Some shoes 8 Their teacher

need to SWoT for macdonald ? Revised Objectives and Marketing Strategy Objectives - Based on the SWOT analysis and the Growth Opportunities analysis, establish the marketing, financial and...

2. In this chapter, the reader should reflect on the following concepts: The trimming effect, vision, steady course paradox, bottom line, prisoners dilemma, social dilemma, CI strategy, CCI strategy,...

3. In what way can preconceptions affect what we perceive in new situations?

7. List examples from your everyday situation where using the CI strategy could have provided a better solution in a communication situation than the solutions you chose.