Letter grades with IFS
Turn a score into a grade without deeply nested IFs.
The formula
Excel and Google Sheets · Excel 2019 and newer
=IFS(A2>=90, "A", A2>=80, "B", A2>=70, "C", A2>=60, "D", TRUE, "F")For Excel 2016 and older
=IF(A2>=90, "A", IF(A2>=80, "B", IF(A2>=70, "C", IF(A2>=60, "D", "F"))))How it works
A2>=90, "A"Pairs of test and result, checked from left to right. The first true test wins.
TRUE, "F"A catch-all for everything else, so the formula never returns #N/A.
Example
| A: Score | B: Grade |
|---|---|
| 93 | A |
| 78 | C |
| 55 | F |
Tips
- Order matters: always test the highest band first.