## How to use the NOT function

*Article updated on April 19, 2018*

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

TRUE returns FALSE and FALSE returns TRUE.

Formula in cell C3:

=NOT(B3)

### 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 8 articles have formulas that contain the NOT function.

Question: How do I create a random list of unique numbers from say 1 to 10, without using VBA and […]

Question: This article is terrific. Thanks so much for posting this solution! I do have one question: Let's say my […]

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 […]
Question: how can i get the date range as : 01/01/09 - 01/15/09, 01/16/09 - 01/31/09 and so on I […]

Question: I have a table with four columns, Date, Name, Level, and outcome. The range is from row 3 to […]

In a previous post I described how to do lookups in a related table. In this post I am going […]

Learn how to sort cell values by frequency.

The following formula in cell D3 counts cells with values stored as text. =SUMPRODUCT(ISTEXT(B3:B14)*1) In other words, cells containing nothing, errors, […]

### Functions in 'Logical'

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

The image above demonstrates the AND function with two logical expressions. If the value in column B is equal to […]

The FALSE function returns the logical (boolean) value FALSE. Excel Function Syntax FALSE() Arguments The FALSE function has no arguments. […]

Checks if a logical expression is met. Returns a specific value if TRUE and another specific value if FALSE.

If the value argument returns an error, the value_if_error argument is used. If the value argument does NOT return an error, the IFERROR function […]

The IFNA function handles #N/A errors only, it returns a specific value if the formula returns a #N/A error. Formula […]

The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first […]

The NOT function returns the boolean opposite to the given argument. TRUE returns FALSE and FALSE returns TRUE. Formula in […]

The above picture shows OR function examples in column D. If the value in column B is equal to a […]

The SWITCH function returns a given value determined by an expression and a list of values. If the expression matches […]

Returns the logical (boolean) value TRUE. Excel Function Syntax TRUE() Arguments The TRUE function has no arguments. Comments Excel interprets […]