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

The Excel cells are given as follows:

E5 is no. of days rented

F5 is Payment Method

G5 is Daily Rate

H5 is Total

E6 is 3

F6 is Credit Card

G6 is $49.99 Cell B42 is 20% (which I named the cell Discount)