· Using an IF function, determine whether or not you have the highest Final Grade. Display either "Yep" or "Nope" as a result of this function. Do not use any hardcoded values for the IF function (that is, do not just plug in numbers you see in the table and enter them in the function; you will only get credit if you use references). Tip: you will need the MAX function to determine if your grade is the highest.

What would I use as the Formula if I had to include the Max in the Formula?

letter grade
J4 A
J5 A-
J6 B
J7 A-
J8 B+

Thanks!