Help with Excel functions

Hello Community,

I'm in desperate need of help with a problem for my accounting class. I've attached the file. The problem is: 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 function down the column to cell H32. I've tried all types of variations of the =IF function and I got nowhere.  Thanks for the help.