Question

In cell h6, 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 b42. if no discount should be applied, the formula should return a zero. use the named range for cell b42, not the cell address, in this formula. copy the formula to the range h7:h32

Answer 1

Answer:

The formula entered in cell H6 is given below:

IFERROR(IF(OR(F6="ExpressMiles",F6="Rewards"),VLOOKUP(A6,RentalRates,2,FALSE),0),0)

Further Explanation:

The Excel sheet information is given as below:

• E5 represents the number of days rented.
• F5 represents the payment method.
• G5 represents the payment method.
• H5 represents the total.
• E6 is 3.
• F6 is credit card.
• G6 is $49.99.
• Cell B42 is 20%

The above formula shows that if the payment is done through Express Miles or Rewards then the discount would be applicable on the payable amount. The discounted value will be shown in cell H6. Otherwise, if any other payment mode is applied then the available discount will be 0 and return the value 0 in cell H6. Since in this case, the payment method is Credit cards. Therefore, there is no discount amount is given or cell H6 return a value of 0.

The figure shows the corresponding excel sheet as below:

Learn more:

1. A company that allows you to license software monthly to use online is an example of ? brainly.com/question/10410011

2. Prediction accuracy of a neural network depends on _______________ and ______________. brainly.com/question/10599832  

3. The shape of our galaxy was determined ‘on the inside looking out' by surveying the milky way using ____________ telescopes. brainly.com/question/7866623  

Answer details:

• Grade: High School
• Subject: Commerce
• Chapter: Accounting

Keywords:

Cell H6, enter a formula, discount, payment method, express miles, rewards, discount, B42, no discount, return a zero, range, cell address, copy the formula, range H7:H32

Answer 2

The formula that will be entered in Cell H6 is provided below:

Cell H6 = If(OR(F6="Express Miles", F6="Rewards"),(E6*G6)*(Discount),0)

The formula indicates that if the payment is made through Express Miles or Rewards, than a discount would be applicable on the amount payable and the value of discount to be applied will appear in Cell H6. However, if any other payment mode/method is used, no discount will be available and Cell H6 would return a value of 0. In the given case since Cell F6 has "Credit Card" as the payment method, Cell H6 will have a value of 0.