# How to use the NOT function

**What is the NOT function?**

The NOT function returns the Boolean opposite to the given argument. TRUE returns FALSE and FALSE returns TRUE.

**What is a Boolean value?**

A Boolean value in Excel is a value that can only be TRUE or FALSE. It represents binary logic and is the result of a logical expression using logical operators or a result of a few Excel functions that I'll discuss below.

Mastering Boolean logic and logical expressions is key to manipulating data and controlling workflow in Excel.

**What is binary logic?**

Binary logic refers to values having one of two states, TRUE or FALSE. This allows Boolean algebra in Excel using logical operators.

**What is a logical expression?**

A logical expression is a statement that evaluates to TRUE or FALSE. For example:

=A1<4

These expressions use comparison operators to evaluate a condition and produce a Boolean result.

**What are the comparison operators?**

= - equal sign

< - less than sign

> - greater than sign

These operators let you build more operators like this:

<> - not equal to

<= - less than or equal to

>= - greater than or equal to

These comparison operators let you create logical expressions like: A2<>5 meaning if the value in cell A2 is not equal to 5, the result is either TRUE or FALSE.

**What are the logical operators?**

The main logical operators in Excel are:

- AND - Returns TRUE if all conditions are true
- OR - Returns TRUE if any condition is true
- NOT - Negates a logical expression
- XOR - Returns TRUE if only one condition is true

**Which functions returns the Boolean value TRUE or FALSE?**

Excel Function and Arguments | Description |
---|---|

AND(logical1, logical2, ...) | Returns TRUE if all arguments are TRUE |

OR(logical1, logical2, ...) | Returns TRUE if any argument is TRUE |

NOT(logical) | Reverses the logic of its argument |

XOR(logical1, logical2, ...) | Returns TRUE if an odd number of arguments are TRUE |

ISEVEN(number) | Returns TRUE if number is even |

ISFORMULA(value) | Returns TRUE if value is a formula |

ISLOGICAL(value) | Returns TRUE if value is logical value |

ISNA(value) | Returns TRUE if value is #N/A error |

ISNONTEXT(value) | Returns TRUE if value is not text |

ISNUMBER(value) | Returns TRUE if value is number |

ISODD(number) | Returns TRUE if number is odd |

ISREF(value) | Returns TRUE if value is reference |

ISTEXT(value) | Returns TRUE if value is text |

ISBLANK(value) | Returns TRUE if value is blank |

ISERR(value) | Returns TRUE if value is error except #N/A |

ISERROR(value) | Returns TRUE if value is any error |

### NOT function Syntax

NOT(*logical*)

### NOT function Arguments

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

### NOT function example

Formula in cell C3:

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

### 'NOT' function examples

In this blog post I will demonstrate methods on how to find, select, and deleting blank cells and errors. Why […]

Table of Contents Count cells with text Count cells with text excluding cells containing a space character Count text values […]

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

### Functions in 'Logical' category

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

## How to comment

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

Convert less than and larger than signsUse 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 OscarYou can contact me through this contact form