Скачать или смотреть How to use Formula for Grade in Excel How to calculate students grades in Excel

This formula checks if the score in B2 is 90 or above, assigning "A" if true.
If not, it checks if it's 80 or above for a "B", and so on.
The final "F" is the result if none of the preceding conditions are met.

Apply the formula to other cells: Click on the cell with the formula (e.g., C2). Then, double-click the small square (the fill handle) in the bottom-right corner of the cell to copy the formula down to all students.

Using the IFS Function (Excel 2019 and newer) The IFS function simplifies grading when you have many conditions, eliminating the need for nested IF statements.

Enter the formula: In your grading column, type

Alternative: Using VLOOKUP and a Grade Table For more complex or frequently changing grading scales, a VLOOKUP function is highly efficient.

1. Create a grading table:
In a separate area of your spreadsheet, create a table with at least two columns: one for the minimum score of a grade and another for the grade itself.

2. Enter the VLOOKUP formula:
In your student's grade cell, enter a formula like this, referencing your grading table: