Google Sheets Function

NOT

Reverses the logical value of its argument.

Generate a formula with AI Same function in Excel

This function works the same in Google Sheets as it does in Excel — same syntax and arguments.

Syntax

NOT(logical)

The NOT function returns TRUE if the argument is FALSE, and FALSE if the argument is TRUE. It is typically used to invert the result of another logical test within a formula.

Arguments

logicalrequiredA value or expression that can be evaluated to TRUE or FALSE.

Examples

=NOT(TRUE)

Result: FALSE

Returns FALSE because the input is TRUE.

=NOT(10>20)

Result: TRUE

The expression 10>20 is FALSE, so NOT reverses it to TRUE.

FAQ

What happens if the argument is a number?

Excel treats 0 as FALSE and any non-zero number as TRUE.

Related functions

AND OR IF