Establishing a rating using a possible second column

[Hollywood9819]

I'm trying to figure out how the set a "SUP", "SAT", and/or "UNSAT" rating in a column for grading purposes. **For Instance**

Column A (Initial Test) a student scored a 50%
Column B (Restest) the student scored an 80%

The column in question would be Column C (Final Rating) - How do I set up a formula that will grant the student a "SAT" rating instead of "UNSAT" for passing the retest?

(NOTE) I figured out how to get the rating to auto-populate from column A, however I can not figure out how to get the formula to read the column B (in the event the student passes a retest.

grade ratings:
>89.99=SUP
>69.99=SAT
<69.99=UNSAT

Current formula I am working with example: =IF(C10>89.99,"SUP",IF(C10>69.99,"SAT",IF(C10>=0,"UNSAT")))

 

[mdiller]

Column C should show the max of the two tests: "Final Rating=Max(Initial Test, Retest)" or "C10=Max(A10,B10)". Then D10=equation above