Excel NOT function

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 )


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.



Leave a Comment

Your email address will not be published. Required fields are marked *