NOT
Definition of NOT
Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`.
Sample Usage
NOT(A2)
NOT(ISERR(A2))
Syntax
NOT(logical_expression)
logical_expression
- An expression or reference to a cell holding an expression that represents some logical value, i.e.TRUE
orFALSE
.
Notes
- Because
0
has a logical value ofFALSE
and any non-zero numeric value has a logical value ofTRUE
,NOT(0)
returnsTRUE
andNOT(6)
returnsFALSE
. However, when non-numeric values are input intoNOT
, the function returns the error#VALUE!
.
See Also
FALSE
: Returns the logical value `FALSE`.
TRUE
: Returns the logical value `TRUE`.
In order to use the NOT formula, start with your edited Excellentable
Then type in the NOT Formula in the area you would like to display the outcome:
Type in the complete NOT formula for a cell as shown below:
Excellentable will generate the outcome when hitting enter.