What is the syntax for NOT in Excel?

The syntax for NOT is: =NOT(logical)

What are common errors with NOT?

Only accepts one argument. Returns opposite of input logic

What does NOT function do in Excel?

NOT reverses TRUE to FALSE and FALSE to TRUE. It's used to invert logical conditions. =NOT(TRUE) returns FALSE. =NOT(A1>10) returns TRUE when A1 is 10 or less. Useful for checking negative conditions.

How do I use NOT with IF?

Use NOT to check for the opposite condition: =IF(NOT(ISBLANK(A1)), "Has Value", "Empty"). This is cleaner than =IF(ISBLANK(A1), "Empty", "Has Value") when you want to emphasize the positive case first.

Can NOT be used with AND and OR?

Yes: =NOT(AND(A1>0, B1>0)) is TRUE if either A1 or B1 is not positive. =NOT(OR(A1=1, A1=2)) is TRUE if A1 is neither 1 nor 2. NOT inverts the entire result of AND/OR.

How do I check if a cell does NOT contain specific text?

Use =NOT(ISNUMBER(SEARCH("text", A1))) to check if A1 doesn't contain "text". Or =ISERROR(SEARCH("text", A1)) which returns TRUE if text is not found.

What is the difference between NOT and <>?

NOT inverts a logical value. <> is a comparison operator meaning 'not equal'. =NOT(A1=10) and =A1<>10 give the same result, but NOT can invert any logical expression, not just equality checks.

Logical

NOT Function in Excel

Reverses the logic of its argument. Returns FALSE if argument is TRUE, and TRUE if argument is FALSE.

Syntax

=NOT(logical)

Arguments

logical (required): A value or expression that evaluates to TRUE or FALSE

Examples

=NOT(A1>100) - TRUE if A1 is NOT greater than 100 - Result: TRUE or FALSE
=IF(NOT(ISBLANK(A1)), A1, "Empty") - Check if cell is not blank - Result: Value or Empty
=NOT(OR(A1=1, A1=2)) - TRUE if A1 is neither 1 nor 2 - Result: TRUE or FALSE

Using NOT in business rules

Build logical tests that return clear outcomes (Yes/No, Pass/Fail, tier labels).
Combine with [AND](/functions/and/) and [OR](/functions/or/) for multi-condition rules.
For many branches prefer [IFS](/functions/ifs/) over deeply nested IF.
Compare patterns in [IF vs IFS](/compare/if-vs-ifs/).

Common errors

Only accepts one argument
Returns opposite of input logic

Use cases

Inverting conditions
Negative filtering
Exception logic

Frequently asked questions

What does NOT function do in Excel? NOT reverses TRUE to FALSE and FALSE to TRUE. It's used to invert logical conditions. =NOT(TRUE) returns FALSE. =NOT(A1>10) returns TRUE when A1 is 10 or less. Useful for checking negative conditions.
How do I use NOT with IF? Use NOT to check for the opposite condition: =IF(NOT(ISBLANK(A1)), "Has Value", "Empty"). This is cleaner than =IF(ISBLANK(A1), "Empty", "Has Value") when you want to emphasize the positive case first.
Can NOT be used with AND and OR? Yes: =NOT(AND(A1>0, B1>0)) is TRUE if either A1 or B1 is not positive. =NOT(OR(A1=1, A1=2)) is TRUE if A1 is neither 1 nor 2. NOT inverts the entire result of AND/OR.
How do I check if a cell does NOT contain specific text? Use =NOT(ISNUMBER(SEARCH("text", A1))) to check if A1 doesn't contain "text". Or =ISERROR(SEARCH("text", A1)) which returns TRUE if text is not found.
What is the difference between NOT and <>? NOT inverts a logical value. <> is a comparison operator meaning 'not equal'. =NOT(A1=10) and =A1<>10 give the same result, but NOT can invert any logical expression, not just equality checks.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.