Quick Answer

NOT Function

NOT flips TRUE to FALSE and FALSE to TRUE.

Syntax

NOT

(logical)

Parameters

Parameter	Description	Required
logical	The condition to reverse.	Required

Basic Example

Reverse a condition

=NOT(A1>100)

ResultFALSE

Returns FALSE when A1 > 100 is TRUE, and vice versa.

Advanced Examples

Example 1: NOT with AND

Complex logic

Check that NOT all conditions are true

=NOT(AND(A1>0, B1>0))

Result: TRUE

Returns TRUE when at least one value is not positive.

How NOT Works

NOT simply reverses the boolean value of its argument.

1

Define condition

Determine the condition to reverse.

2

Enter formula

Type =NOT(condition).

3

Press Enter

The result is the opposite of the condition.

Important Notes & Limitations

NOT only takes one argument.
For negating multiple conditions, use NOT with AND/OR.

Common Errors & Fixes

#VALUE!Non-boolean argument

Fix: Ensure the argument evaluates to TRUE/FALSE.

Download Practice File

Practice NOT with Real Data

Download a sample CSV file with pre-populated data and practice exercises for the NOT function. Works in both Excel and Google Sheets.

Works in Google SheetsCompatible with ExcelIncludes exercises

File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps

Related Functions

AND

AND checks if ALL conditions are TRUE.

FALSE

Returns the logical value FALSE.

IF

IF checks a condition and returns different values based on whether it is true or false.

IFERROR

IFERROR catches errors and returns a custom value instead.

IFNA

Replaces #N/A errors with a fallback value.

IFS

A simpler way to write multiple IF statements without nesting.

Frequently Asked Questions

Can NOT be used with arrays?

Yes, in Excel 365 and Google Sheets, NOT works with arrays.