ExcelHeroThe IFS function
Checks several tests in order and returns the first match.
In German Excel: WENNS
How to write it
=IFS(test1, value1, [test2, value2], …)- test1, value1
- The first test and its answer.
- test2, value2
- More pairs.
💡 End with TRUE, "…" to catch everything else.
Try it
Give Aisha a grade: 90+ is A, 80+ is B, 70+ is C, the rest D.
A
B
C
1
Student
Score
Grade
2
Aisha
88
3
Ben
54
4
Chloe
97
5
Dev
71
6
Emma
63
7
Finn
79
Start with the highest bar: B2>=90 first.