Exercises / Logic and decisions · 6 of 9
Letter grades with IFS
IFS(test1, value1, test2, value2, …) returns the value of the first TRUE test. It replaces a chain of nested IFs. End with TRUE, value as a catch-all, or IFS returns #N/A when nothing matches.
Your taskIn C2, use IFS to return "A" for 90+, "B" for 80+, "C" for 70+, "D" for 60+, and "F" otherwise, for the score in B2. It will be copied down to C9.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C |
|---|---|---|---|
| 1 | Student | Score | Grade |
| 2 | Ilir | 95 | |
| 3 | Jana | 83 | |
| 4 | Kofi | 67 | |
| 5 | Lea | 74 | |
| 6 | Mats | 52 | |
| 7 | Nora | 90 | |
| 8 | Omar | 61 | |
| 9 | Pia | 88 |