Grades with IFS
A nested IF puts one IF inside another. IFS takes a flat list of pairs instead: a test, the value when it is true, the next test, its value, and so on.
Click Continue when you're ready.
Already know it? Type the formula straight into C2.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Student | Score | Grade | |||
| 2 | Jonas | 76 | ||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Why this works
IFS checks its tests from left to right and returns the value after the first one that is TRUE. 76 is not >= 90, but it is >= 70, so the result is B. TRUE is always true, so as the last test it catches everything the others did not, like the last argument of a nested IF.
Common mistake: Leaving out the TRUE at the end. A score under 70 then matches no test, and IFS returns #N/A.
The answer
- C2
=IFS(1B2>=90,2"A",3B2>=70,4"B",5TRUE,6"C")
In plain words: 1If the score in B2 is 90 or more, 2give an A. 3If it is 70 or more, 4give a B. 5In every other case, 6give a C.
+15 points