Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
NOT
NOT inverts a Boolean value or logical expression — TRUE becomes FALSE and FALSE becomes TRUE. Use it to test for the absence of a condition, such as cells that are not blank, do not contain a keyword, or fail a validation check, making it easy to build inverse logic without restructuring a formula.
Excel
=NOT(ISBLANK(A2))Google Sheets
=NOT(ISBLANK(A2))✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Status | Has Value? |
| Active | =NOT(ISBLANK(A2)) |
| Pending | =NOT(ISBLANK(A3)) |
| =NOT(ISBLANK(A4)) | |
| Closed | =NOT(ISBLANK(A5)) |
=NOT(ISBLANK(A2))→TRUE
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Identify the logical condition you want to invert — for example, ISBLANK(A2) returns TRUE when A2 is empty.
- 2Wrap it with NOT: =NOT(ISBLANK(A2)) returns TRUE when A2 is not blank, and FALSE when it is.
- 3Combine with IF: =IF(NOT(ISBLANK(A2)),"Has value","Empty") to label cells based on the inverted condition.