Classifying grades

You have a list of student grades in column A, where A2 contains the value 85. You want to classify grades into letter grades as follows:

• A: 90 and above
• B: 80 or above and below 90
• C: 70 or above and below 80
• D: Below 70

Which formula would you use in cell B2 to assign the correct letter grade based on the numeric grade in A2?

• =IF(A2>=90, "A", IF(A2>=80, "B", IF(A2>=70, "C", "D")))
• =IF(A2>=90, "A", IF(A2>=80, "C", IF(A2>=70, "B", "D")))
• =IF(A2<=90, "A", IF(A2<=80, "B", IF(A2<=70, "C", "D")))
• =IF(A2=90, "A", IF(A2=80, "B", IF(A2=70, "C", "D")))