I need to figure out what formula to enter to determine a discount to be applied? 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 zero. Use the names range for cell B42, not the cell address, in this formula.
Solved by C. Y. in 21 mins