## How to use the NOT function

*Article updated on February 16, 2018*

The NOT function returns the boolean opposite to the given argument.

TRUE returns FALSE and FALSE returns TRUE.

Formula in cell C3:

### Excel Function Syntax

NOT(*logical*)

### Arguments

logical |
Required. A boolean value or it's equivalent. TRUE = 1 and FALSE equals 0. |

### Comments

Note, the NOT function returns TRUE for a blank cell, see cell B8 and C8.

### Articles with the 'NOT' Function

The following 7 articles have formulas that contain the NOT function.

Extract unique distinct values sorted based on sum of adjacent values

Table of Contents Filtering unique distinct text values and sort them based on sum of adjacent values Filtering unique distinct […]### Functions in 'Logical'

The NOT function function is one of many functions in the 'Logical' category.