Pass or fail with IF
Step 1 of 3
IF makes a choice. It checks a test, then shows one value when the test is true and another when it's false: =IF(test, value_if_true, value_if_false).
Click Continue when you're ready.
Already know it? Type the formula straight into C2.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Student | Score | Result | |||
| 2 | Anna | 62 | ||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Need help?
Why this works
IF takes a test, a value for when the test is TRUE and a value for when it is FALSE. 62 >= 50 is TRUE, so the cell shows Pass. Text answers go in double quotes.
Common mistake: Leaving out the quotes around the text answers. Without them Excel reads Pass as a name and shows #NAME?.
The answer
- C2
=IF(1B2>=50,2"Pass",3"Fail")
In plain words: 1If the score in B2 is 50 or more, 2show Pass. 3Otherwise show Fail.
=IF(test, value_if_true, value_if_false), for example =IF(B2>=50,"Pass","Fail"). Put text results in double quotes.
+10 points