## 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.