Syntax
=NOT(logical_expression)
logical_expression- A TRUE/FALSE value or condition to reverse.
NOT function in Google Sheets
NOT reverses a TRUE/FALSE value. It's useful for flipping a checkbox or turning "is blank" into "is filled in".
Practice NOT
Task 1 of 1
Discontinued items shouldn't appear in the store. Use NOT to turn the Discontinued flag in B2 into a "Show in store?" TRUE/FALSE in C2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
NOT examples
Each example below runs against this sample sheet. The results are calculated by the same engine as the practice grid.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Student | Class | Score | Passed |
| 2 | Priya | A | 92 | TRUE |
| 3 | Leo | B | 67 | FALSE |
| 4 | Chloe | A | 48 | FALSE |
| 5 | Mateo | B | 81 | TRUE |
| 6 | Ines | C | FALSE | |
| 7 | Kai | C | 75 | TRUE |
| Formula | Result | What it shows |
|---|---|---|
=NOT(D3) | TRUE | Leo did not pass, so NOT gives TRUE. |
=NOT(C2>=70) | FALSE | Same as C2<70. |
=IF(NOT(ISBLANK(C6)), "Has score", "No score") | No score | Turning ISBLANK around. |
Tips and common mistakes
- Often a simpler comparison does the job: NOT(A2="x") is the same as A2<>"x".
Related functions
Learning step by step? NOT is covered in Lesson 7: AND, OR, NOT & XOR of the free course.