Excel, Data, Data Analysis, Analytics.
the grade “B”. IF(B2 >= 70, “C”, …) If the score is not 80 or above, it checks if it’s greater than or equal to 70. If true, it assigns the grade“C”. If none of the above conditions are met (meaning the score is less than 70), it assigns the grade “D”. As always, check that the output is what you