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(20%). 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.