Definition of NOT

Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`.

Sample Usage





  • logical_expression - An expression or reference to a cell holding an expression that represents some logical value, i.e. TRUE or FALSE.


  • Because 0 has a logical value of FALSE and any non-zero numeric value has a logical value of TRUENOT(0) returns TRUE and NOT(6) returns FALSE. However, when non-numeric values are input into NOT, 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. 


User does not have sufficient privileges to access this Content
Learn More