Learner 2 is in row 3. Write a formula that returns "Pass" if their score is 50 or more, otherwise "Fail".
| A | B | C | |
|---|---|---|---|
| 1 | Learner | District | Score |
| 2 | Learner 1 | Huye | 72 |
| 3 | Learner 2 | Musanze | 45 |
| 4 | Learner 3 | Huye | 88 |
| 5 | Learner 4 | Rubavu | 59 |
| 6 | Learner 5 | Musanze | 91 |
| 7 | Learner 6 | Huye | 50 |
Sign in to join the discussion.