All functions / Logical

NOT

Flips TRUE to FALSE and FALSE to TRUE.

Syntax

=NOT(logical)

Arguments

• logical: A condition.

Example

=NOT(B2="Done") → TRUE when not done

Practise it

• AND, OR and NOT
• Spotting problems with IS functions