How to use the NOT function
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.
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.
Articles with the 'NOT' Function
The following 5 articles have formulas that contain the NOT function.
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 […]
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 […]
Extract unique distinct values from a related table
In a previous post I described how to do lookups in a related table. In this post I am going […]
List all unique events in a month
Question: I have a table with four columns, Date, Name, Level, and outcome. The range is from row 3 to […]
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, […]
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.
How to use the 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 […]
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 OR function allows you to carry out a logical test in each argument and if at least one argument returns […]
How to use the SWITCH function
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 […]
The XOR function was introduced in Excel 2013 and calculates the logical exclusive OR meaning if at least one of the […]
English
Spanish
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