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