NOT
Flips TRUE to FALSE, and FALSE to TRUE.
How it’s written
NOT(test)Example
| A | B | |
|---|---|---|
| 1 | Name | Score |
| 2 | Amara | 72 |
| 3 | Ben | 90 |
| 4 | Chloe | 65 |
| 5 | Dev | 90 |
| 6 | Elena | 83 |
=NOT(B2>=80)Result: TRUE
72 isn’t at least 80, so NOT gives TRUE.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Often a simpler test reads better than NOT. Try B2<80 first.
Practice it properly
Rules with several parts gives you real tasks, with your formulas tested on data you haven’t seen.