NOT
Reverses the logic of its argument.
LogicalLogic & ConditionsMost Used
What it does
Reverses a logical value: TRUE becomes FALSE and FALSE becomes TRUE.
Syntax
NOT(logical)
Arguments
logical(logical) — Value to invert.
Examples
Invert a check
Invert whether a value is blank.
FORMULA
=NOT(A2="")
RESULT
false
SAMPLE DATA
| A | |
|---|---|
| 1 | Text |
| 2 | |
| 3 | Hello |