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

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 ?

2. Prediction accuracy of a neural network depends on _______________ and ______________.  

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

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

the difference is right there dont you see it