IFS
Checks tests in order, and returns the result for the first true one.
How it’s written
IFS(test1, result1, test2, result2)Example
| A | B | |
|---|---|---|
| 1 | Name | Score |
| 2 | Amara | 72 |
| 3 | Ben | 90 |
| 4 | Chloe | 65 |
| 5 | Dev | 90 |
| 6 | Elena | 83 |
=IFS(B2>=90,"A",B2>=70,"B",TRUE,"C")Result: B
72 fails the first test and passes the second.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Finish with TRUE as a catch-all, or unmatched values return #N/A.
Practice it properly
Many outcomes with IFS and SWITCH gives you real tasks, with your formulas tested on data you haven’t seen.