Excel, Data, Data Analysis, Analytics.
formula: =IF(B2 >= 90, “A”, IF(B2 >= 80, “B”, IF(B2 >= 70, “C”, “D”))) Then, drag this formula down along your list of student scores to apply the grading logic to all students. Make sure to double-check how the formula is applied and if the results are accurate. Let’s break down this formula: