Assign a grade from score bands
Check score bands from the top down and return the first grade that matches.
The formula
=IFS(A2>=90,"A", A2>=80,"B", A2>=70,"C", TRUE,"F")How it works
| A | |
|---|---|
| 1 | Score |
| 2 | 85 |
Result
B
Checked top-down: 85 is not >= 90 but it is >= 80, so the grade is B.