NOT
Formulas / NOTReverse 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.
Frequently Asked Questions
What is the NOT function?
What happens when the NOT function is used?
Where is the NOT function used?
What is the syntax for the NOT function?
What are the arguments for the NOT function?
