Summary

The Excel NOT function reverses a logical result. If the original result is TRUE, NOT returns FALSE. If the original result is FALSE, NOT returns TRUE.

NOT is useful when a workbook needs to focus on exceptions, missing items, or failed checks instead of passed checks. It often appears inside larger formulas where the "negative" version of a test is easier to read than rewriting the entire condition from scratch.

Syntax

=NOT(logical)

NOT takes one argument: a logical value or a formula that evaluates to TRUE or FALSE.

Arguments

• logical - [required] A logical value, comparison, or formula result to reverse.

This argument can be a direct value such as TRUE, a comparison such as A1=100, or the output of another logical function.

NOT vs Other Logical Functions

NOT is not usually used by itself for large decisions. More often, it sits around another logical test to flip the final answer.

Using NOT

NOT is useful when the negative version of a rule is easier to express. For example, instead of asking "is this record valid?", a worksheet might need to ask "is this record not valid?" or "is this item not complete yet?" In those cases, NOT makes the formula easier to read.

A very common pattern is NOT(ISBLANK(A1)). That formula returns TRUE when a cell contains something and FALSE when it is empty. It is often easier to understand than writing a more indirect blank check manually.

One practical tip is to avoid unnecessary double negatives. A formula such as NOT(A1<>10) is valid, but many readers will find it harder to understand than the simpler equivalent A1=10. When possible, choose the clearer version.

Example 1 - Reverse a Simple TRUE/FALSE Result

The most direct use of NOT is flipping a logical value.

=NOT(TRUE)

This returns FALSE. It is a simple way to see exactly what the function does before using it inside larger formulas.

Example 2 - Check Whether a Value Is Not Equal

NOT can wrap a comparison when you want to emphasize the opposite outcome.

=NOT(B2=100)

This returns TRUE when B2 is anything other than 100. It works, although the simpler comparison B2<>100 is often easier to read.

Example 3 - Check Whether a Cell Has Data

NOT is often combined with ISBLANK for data-entry validation.

=NOT(ISBLANK(B2))

This returns TRUE when the cell contains a value and FALSE when it is blank. It is a very common pattern in input checks and required-field rules.

Example 4 - Flag a Missed Target

You can also use NOT to flip a target comparison.

=NOT(B2=G2)

This returns TRUE when the actual value does not match the target. Similar patterns can be used to highlight failed benchmarks or missing matches.

Conclusion Recap

• Summary: NOT returns the opposite of a logical result.
• Best use: It is useful for exclusions, negative checks, and exception-focused logic.
• Common pattern: NOT(ISBLANK(cell)) checks whether a cell has data.
• Readability tip: Avoid double negatives when a simpler comparison says the same thing.
• Practical use: Wrap comparisons or logical functions when you need the opposite answer.
• Good pairing: NOT often works well with IF, ISBLANK, AND, and OR.