How to use the NOT function

Author: Oscar Cronquist Article last updated on May 18, 2022

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.

'NOT' function examples

The following 17 articles have formulas containing the NOT function.

Count cells with text
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, […]

Create unique distinct list sorted based on text length
The formula in cell D3 extracts unique distinct values from B3:B20 sorted based on the number of characters, it works […]

Extract duplicate values with exceptions
This article demonstrates formulas that extract duplicate values from a column, however, column D contains values that you don't want […]

Extract unique distinct values from a relational table
In this post, I am going to show you how to extract unique distinct values and duplicates using a formula, […]

Extract unique distinct values sorted based on sum of adjacent values
Filtering unique distinct text values and sort them based on the sum of adjacent values can easily be done by […]

Filter common values between two ranges
The image above shows an array formula in cell B12 that extracts values shared by cell range B2:D4 (One) and […]

Filter unique distinct records
Table of contents Filter unique distinct row records Filter unique distinct row records but not blanks Filter unique distinct row […]

Filter values that exists in all three columns
This article explains how to extract values that exist in three different columns, they must occur in each of the […]

Highlight odd/even months
Color odd months Conditional formatting formula: =MOD(MONTH($B6),2) Explaining CF formula in cell B6 Step 1 - Calculate number of month The […]

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

If cell contains any text
The picture above shows different values in column B and a formula in column C that tries to identifies the […]

List all unique distinct rows in a given month
This article demonstrates a formula that extracts unique distinct records/rows for a given month specified in cell C2, see the […]

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

Sort a range based on value frequency
The formula in cell B8 extracts a list sorted based on frequency. Array formula in B8: =TEXTJOIN("", TRUE, IF(MIN(IF((MAX(IF(COUNTIF($B$7:B7, $B$2:$E$5)=0, […]

SUMPRODUCT if not blank
This article describes ways to work with the SUMPRODUCT function and blanks, error values, N/A# errors. Table of Contents SUMPRODUCT […]

True round-robin tournament
Mark G asks in Create a random playlist in excel: Can this example be modified to create a true round-robin […]

Wildcard lookups and include or exclude criteria
This article demonstrates three different ways to filter a data set if a value contains a specific string and if […]

Functions in 'Logical' category

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

AND function

Perform a logical test in each argument and if all arguments return TRUE the AND function returns TRUE.

FALSE function

Returns the logical (boolean) value FALSE.

IF function

Returns one value if the logical test is TRUE and another value if the logical test is FALSE.

IFERROR function

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 returns the value argument.

IFNA function

Handles #N/A errors only, it returns a specific value if the formula returns a #N/A error.

IFS function

Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

NOT function

Returns the boolean opposite to the given argument.

OR function

Evaluates a logical expression in each argument and if at least one argument returns TRUE the OR function returns TRUE. If all arguments return FALSE the OR function also returns FALSE.

SWITCH function

Returns a given value determined by an expression and a list of values.

TRUE function

Returns the logical (boolean) value TRUE.

XOR function

Calculates the logical exclusive OR meaning if at least one of the arguments evaluates to TRUE then the XOR returns TRUE. All arguments must be evaluated to FALSE for the XOR function to return FALSE.

How to comment

How to add a formula to your comment
<code>Insert your formula here.</code>

Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >

How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.

Contact Oscar

You can contact me through this contact form