NOT
Turn TRUE into FALSE and FALSE into TRUE.
Syntax
NOT(logical)| Argument | Required | Description |
|---|---|---|
logical | Required | The condition to invert. |
Examples
Every example below was executed against VisiGrid engine 0.35.0 — not
transcribed from another vendor's documentation. Reproduce any of them with vgrid calc.
| Formula | Result | Notes |
|---|---|---|
=NOT(TRUE) | FALSE | |
=NOT(A1>100) | TRUE |
Usually avoidable
NOT(A1>5) is A1<=5, and the second reads better. NOT earns its place when
the thing being inverted is a function call rather than a comparison:
=IF(NOT(ISERROR(A1)), A1, 0)Even there, IFERROR usually says it more directly.
Reach for NOT when inverting reads more clearly than restating — and against
AND or OR, where there is no simple
opposite to write instead.
Excel compatibility
Matches Excel.