IF
Returns one result if a test is true, and another if it isn’t.
How it’s written
IF(test, if_true, if_false)Example
| A | B | |
|---|---|---|
| 1 | Name | Score |
| 2 | Amara | 72 |
| 3 | Ben | 90 |
| 4 | Chloe | 65 |
| 5 | Dev | 90 |
| 6 | Elena | 83 |
=IF(B2>=70,"Pass","Fail")Result: Pass
Amara’s 72 is at least 70, so the result is Pass.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Keep thresholds like 70 in their own cell, so they’re easy to change.
Practice it properly
Making decisions with IF gives you real tasks, with your formulas tested on data you haven’t seen.