# NOT

Formulas / NOT
Reverse a value.
`=NOT(logical)`
• Logical - required, a value or expression that can be evaluated to true or false

## Examples

• `=NOT(ISBLANK(A1))`

The NOT function is often used in tandem with the ISBLANK function to determine if a cell is empty or not. For example, this will return TRUE if A1 is empty and will return FALSE if A1 is not blank.

• `=NOT(ISERROR(A1))`

The NOT function can also be used in combination with the ISERROR function to determine if a cell contains an error. For instance, this will return TRUE if A1 does not contain an error and will return FALSE if A1 does contain an error.

• `=NOT(ISNUMBER(A1))`

The NOT function can also be used in combination with the ISNUMBER function to determine if a cell contains a number or not. For example, this will return TRUE if A1 does not contain a number and will return FALSE if A1 does contain a number.

• `=IF(NOT(A1="yes"),0,1)`

The NOT function can also be used in combination with the IF function to create more complex logical tests. For example, this will return a 0 if A1 does not equal "yes" and will return a 1 if A1 does equal "yes".

## Summary

The NOT function performs a logical test by reversing the value of its argument. It checks to see if one value is not equal to another, making it a useful logical function.

• The NOT function reverses a logical value, returning the opposite of the logical value given.

What is the NOT function?
The NOT function is a logical function that takes one argument. This argument is a value or expression that is evaluated to either TRUE or FALSE.
What happens when the NOT function is used?
The NOT function returns TRUE if the logical is FALSE, and returns FALSE if the logical is TRUE.
Where is the NOT function used?
The NOT function is used in conditional statements and other logical operations. It can also be used to reverse the truth value of a given expression.
What is the syntax for the NOT function?
The syntax for the NOT function is: NOT(argument).
What are the arguments for the NOT function?
The argument for the NOT function is a value or expression that is evaluated to either TRUE or FALSE.