Spreadsheet Practice

NOT function

Quick answer

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)

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.

Available in
Every current version
Category
Logical functions
Returns
The opposite logical value.
Google Sheets
Works the same way in Google Sheets.

Syntax

=NOT(logical)

ArgumentRequired?What it is
logicalRequiredA value or test that is TRUE or FALSE.

Examples

Each result below is calculated from the sample sheet by our formula engine, the same one that grades the practice.

CellFormulaResultWhat it shows
D2=NOT(C2="Yes")FALSEThe task is done, so "not done" is FALSE
D3=NOT(ISBLANK(B3))FALSEThe owner cell is empty, so "has an owner" is FALSE
D4=IF(NOT(C4="Yes"),"Follow up","")Follow upInside IF to act on tasks that aren't done

Try it live

This is the sample sheet. Change any number or text, or edit a formula, and the results update.

Show the sample data as a table
TaskOwnerDoneResult
Draft budgetAnaYesFALSE
Book venueNoFALSE
Send invitesRajNoFollow up

Practice NOT

Graded instantly, then re-checked on changed data.

Reorder list

In D2, return TRUE when an item needs reordering: its stock is not above its reorder level. Use NOT, then fill down to D7.

Common mistakes

What you seeWhy, and how to fix it
Using NOT where <> is simplerNOT(C2="Yes") and C2<>"Yes" give the same result. For a single comparison the <> version is shorter and easier to read.
NOT on a numberNOT 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 cellAn 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)).

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.

Answers that use NOT

In other languages

NOT is NO in Spanish Excel and NICHT in German Excel. Each page has the syntax with semicolons, the examples and the exercise in that language. For other functions and languages, use the Function Translator.

Updated Checked by running: every formula on this page was run by our formula engine on .