The NOT function is one of the logical functions. It is used to check if the logical value you enter is TRUE or FALSE. The function returns TRUE if the argument is FALSE and FALSE if the argument is TRUE.
Syntax
NOT(logical)
The NOT function has the following argument:
Argument | Description |
---|
logical | A value that can be evaluated to TRUE or FALSE. |
Notes
How to apply the NOT function.
Examples
There is an argument: logical = A1<100, where A1 is 12. This logical expression is TRUE. So the function returns FALSE.

If we change the A1 value from 12 to 112, the function returns TRUE:
