Excel, Data, Data Analysis, Analytics.
=IF(B2 >= 90, “A”, IF(B2 >= 80, “B”, IF(B2 >= 70, “C”, “D”))) IF(B2 >= 90, “A”,…) checks if the score in cell B2 is greater than or equal to 90. If true, it assigns the grade “A.” IF(B2 > =80, “B”,…) If the score is not 90 or above, it checks if it’s greater than or equal to 80. If true, it assigns