Question: In cell H 6 , enter a formula to determine any discount that should be applied. If the payment method was Express Miles or Rewards,

In cell H

6,

enter a formula to determine any discount that should be applied. If the payment method was Express Miles or Rewards, the customer should receive the discount shown in B

42 .

If no discount should be applied, the formula should return a zero. Use the named range for cell B

42,

not the cell address, in this formula. Copy the formula to the range H

7

32 .

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 General Management Questions!

Please help me 1 Start Excel. Open the file named e02ch03_grader_as_CarRental.xlsx . Save the file with the name e02ch03_grader_as_CarRental_LastFirst , replacing LastFirst with your last and first...

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...

File Home Insert Draw Page Layout Formulas Data Review View Help B Share 11 fx A B C D E F G H K M N Cost of Amount of Discount Payment Method Gas Gas Option N N Analysis Criteria Rewards Express...

Can someone please provide help with *******NUMBERS 2,4,6,8, & 11********. I'm having trouble with all of these. I keep getting them wrong The name of cell B42 is DISCOUNT ****** need this for the...

Help me answers the following. Instructions 2.On the RentalData worksheet, in cell E6 , enter a date formula to determine the length of rental in days. Copy this formula to the range E7:E32. Hint: In...

tRYING TO FIND THESE FORMULAS! THASNK YOU Step Instruction Earned Possible On the RentalData worksheet, in cell E6, enter a date formula to determine the length of rental in days. Copy this formula...

can i get help on questions 6-10 please? Time Dames M N 1 Car Rental Analysis Express Car Rental Het Werk starting // Created by son tanto 1 4 Are G Option Cost of Gas All C Part Method Average tal...

need help with all of these X V fx =IF(OR(F6="Express Miles",F6="Rewards"),$E$12,0) Date Returned/or Expected Return Amount of punt Gas Option Autold Date Rented Daily Rate Cost of Gas Total Cost 27...

HI, I am sorry to post this Q again because I could not understand the formula. Also, the answer was different from the answer sheet that I should do this project on it. this is the Q: Express Car...

Use Worksheet 2.1. Teresa Blankenship's banker has asked her to submit a personal balance sheet as of June 30, 2015, in support of an application for a $6,000 home improvement loan. She comes to you...

Consider the block diagram of Figure3. Find the transfer function H(s) = Y/X in its simplest form. (Hint: Start with Y3/Y2 block first). (25 points) fotos: (s+1) 1 2s Figure 3

Which of the following is most likely to be disclosed as a loss contingency in the footnotes to the financial statements? a . The guarantee of a debt obligation of a related party, where it is remote...

the mothy The White Wedding Co wrando che in the amount of 54.780, In Authe correny wrote and recorded reques in the amount of 1.660 Orcheques $1,900 were paid by the bank in July and 2.000 were...