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.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of IF
0/4The same formula in the other shapes it takes at work.
- Basic IF Function
Make the sheet decide, instead of deciding row by row yourself.
CoreIntermediate - IF that returns a calculation
The answer to an IF can be a sum, not just a word.
Intermediate - IF for an empty cell
Test for "" before calculating with a cell that might not be filled in yet.
Intermediate - IF against another cell
Each row carries its own threshold; compare to the cell, not a typed number.
Beginner
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 |
Functions used here
What this exercise teachesMay contain 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.