Logical Functions
Intermediate
Basic IF Function
Make the sheet decide, instead of deciding row by row yourself.
Task:
You are marking the end-of-module papers and the pass mark is 80. Rather than typing Pass or Fail forty times a term, put a formula in column C that works it out from the score.
Learning Objectives:
- Write a condition with IF
- Choose >= over > deliberately
- Return text rather than a number
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Student | Score | Result |
| 2 | Priya Raman | 85 | |
| 3 | Tom Whelan | 75 | |
| 4 | Jonas Berg | 92 | |
| 5 | Aisha Noor | 78 | |
| 6 | Marco Ferri | 88 |
What this exercise teaches (contains the answer)
The formula records the rule once. Move the pass mark and every row follows; type the words in by hand and you get forty independent chances to make a mistake, with nothing left on the sheet saying what the rule was.