Exercises / Logic and decisions · 1 of 9
Mark each score Pass or Fail
IF checks a condition and returns one value when it is TRUE and another when it is FALSE.
Your taskIn C2, use IF to return "Pass" when the score in B2 is 60 or more, and "Fail" otherwise.
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 | Result |
| 2 | Arta | 72 | |
| 3 | Blerim | 58 | |
| 4 | Dea | 91 | |
| 5 | Eri | 60 | |
| 6 | Fiona | 43 |