NOT pitfall 1: Wraps a single boolean?

Wraps a single boolean. To negate a row of booleans, use `1-` instead (e.g. `1 - (A:A="x")`).

NOT pitfall 2: NOT(ISBLANK(x)) is a common idiom for "x has any value, even an empty string"?

`NOT(ISBLANK(x))` is a common idiom for "x has any value, even an empty string".

Logiceasy

Returns the opposite of a logical value: NOT(TRUE) = FALSE.

Syntax

=NOT(logical_expression)

Arguments

Argument	Description
logical_expression	An expression or reference holding a logical value to be negated.

Example

=NOT(A1>10)

Paste this into Google Sheets to run it. The live playground on this site covers 24 of the 61 functions, and NOT isn't one of them yet.

Wraps a single boolean. To negate a row of booleans, use 1- instead (e.g. 1 - (A:A="x")).
NOT(ISBLANK(x)) is a common idiom for "x has any value, even an empty string".

Related formulas

Used by