Skip to main content


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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.