# NOT function in Excel

> NOT flips a logical value: TRUE becomes FALSE and FALSE becomes TRUE.

Source: https://spreadsheetpractice.com/functions/not · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** NOT flips a logical value: TRUE becomes FALSE and FALSE becomes TRUE.
- **Syntax:** `=NOT(logical)`
- **Most common use:** `=NOT(C2="Yes")` returns FALSE (The task is done, so "not done" is FALSE)
- **Available in:** Every current version
- **Category:** [Logical functions](https://spreadsheetpractice.com/functions/category/logic)
- **Returns:** The opposite logical value.
- **Google Sheets:** Works the same way in Google Sheets.

## What it does

NOT flips a logical value: TRUE becomes FALSE and FALSE becomes TRUE. It is most useful for turning an existing test around, such as "not blank", "not a number" or "not above the limit", without rewriting the comparison.

## Syntax

`=NOT(logical)`

| Argument | Required? | What it is |
|---|---|---|
| `logical` | Required | A value or test that is TRUE or FALSE. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=NOT(C2="Yes")` | FALSE | The task is done, so "not done" is FALSE |
| D3 | `=NOT(ISBLANK(B3))` | FALSE | The owner cell is empty, so "has an owner" is FALSE |
| D4 | `=IF(NOT(C4="Yes"),"Follow up","")` | Follow up | Inside IF to act on tasks that aren't done |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Task | Owner | Done | Result |
| 2 | Draft budget | Ana | Yes | FALSE |
| 3 | Book venue |  | No | FALSE |
| 4 | Send invites | Raj | No | Follow up |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Using NOT where <> is simpler | NOT(C2="Yes") and C2<>"Yes" give the same result. For a single comparison the <> version is shorter and easier to read. |
| NOT on a number | NOT treats 0 as FALSE and any other number as TRUE, so NOT(5) is FALSE. Wrap the comparison you mean instead, such as NOT(B2>5). |
| NOT on an empty cell | An empty cell counts as FALSE, so NOT(A2) returns TRUE. Use NOT(ISBLANK(A2)) to test whether the cell has something in it. |

## Tips

- NOT reads best around a function that already returns TRUE or FALSE, such as NOT(ISNUMBER(A2)) or NOT(ISBLANK(B2)).

## Related functions

- [AND](https://spreadsheetpractice.com/functions/and): AND returns TRUE only when every condition you give it is TRUE.
- [OR](https://spreadsheetpractice.com/functions/or): OR returns TRUE when at least one of its conditions is TRUE.
- [ISBLANK](https://spreadsheetpractice.com/functions/isblank): ISBLANK returns TRUE when a cell is completely empty.
- [IF](https://spreadsheetpractice.com/functions/if): IF checks a condition and returns one value when it is true and another when it is false.

## Questions

### How do I write "not equal to" in Excel?

Use <>, as in =IF(A2<>"Closed","Open",""). NOT(A2="Closed") does the same thing.

### How do I check that a cell is not blank?

=NOT(ISBLANK(A2)) and =A2<>"" both return TRUE when the cell has something in it.

## Practice

A graded NOT exercise ("Reorder list") is on [the NOT page](https://spreadsheetpractice.com/functions/not). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
