I'm super stumped! I'm still pretty new at Excel and am having a problem with writing out this formula correctly and I have spent many hours and still can't come up with the correct calculations for the formula. EX: . Gwen offers a $5.00 discount to repeat students. Apply this discount as appropriate to the student data as follows: In cell H4, create a formula using the IF function and structured references to determine the correct amount paid based on the following criteria: a. If the Repeat? value is “Yes”, calculate the amount paid by subtracting 5 from the Fee. b. Otherwise, the amount paid is the Fee value.