Excel version in which NOT function can work:
Excel NOT function will work in Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Starter Excel Mobile Excel for Android phones.
About excel NOT function:
Excel NOT function is a logical function, it checks a logical value and returns the opposite logical value.
If input logical value is TRUE it will return the result FALSE .
If the input logical value is FALSE it will return the result TRUE .
Syntax for NOT Function:
=NOT( logical_value )
Parameters
logical_value : A value, expression or formula that either evaluates to TRUE or FALSE.
You can also use numeric values in this, zero is considered as False and any other value considered as True.
Using Excel NOT function:
The result of NOT function will be reverse of logical value
formula: =NOT(TRUE), formula result : FALSE
formula: =NOT(FALSE), formula result : TRUE
For Example:
Logical | Formula | Result | Comment |
200 | =NOT(B3>500) | TRUE | The result of formula is TRUE since the result of input logical check is FALSE. |
Good | =NOT(B4=”Good”) | FALSE | The result of formula is FALAE since the result of input logical check is TRUE. |
NOT function can be combined with any other functions.
You can use the NOT function effectively with IF, AND & OR functions.