*In this article, we are going to learn how to use NOT function in Microsoft Excel.*

*NOT function returns the reversed logical value of its arguments i.e if argument is TRUE, function returns FALSE and vice versa. The argument can be either typed directly or as a reference to a cell that contains a logical value and it always returns the Boolean value only.*

**With the help of examples, let us understand the use of NOT function in Excel.**

Refer to these 5 different examples for the usage of NOT function in Microsoft Excel on the basis of following sample data:

**1 ^{st} Example**:-

In this example, we will enter both true and false logical values and we’ll see how function performs.

**Follow the steps given below**:-

- Enter the function in cell C8
- =NOT(A8) {This function will convert the logical value}
- Press Enter

Function has returned FALSE, because cell A8 contains “TRUE”.

- Now enter =NOT(B8), Press Enter
- Function will return TRUE, as cell B8 contains FALSE

**2 ^{nd} Example**:-

In the next example, we will tell NOT function to check whether A9 is greater than B9 or not. We know that A9 is not greater than B9 but we’ll confirm the same with the function. Follow the steps given below:-

- Enter the function in cell C9
- =NOT(A9>B9)
- Press Enter

The function has returned TRUE, because if we evaluate the function, it would tell us that the condition which passes in the argument is TRUE and hence the function returns FALSE.

**3 ^{rd} Example**:-

Now, let’s see what happens if we give continuous range in the logical argument.

**Follow the steps given below**:-

- Enter the function in cell C10
- =NOT(A10:B10)
- Press Enter

The function has returned #VALUE error because NOT function does not allow any range and can take only one condition.

**4 ^{th} Example**:-

In this example, we’ll see what happens when we use NOT function for numeric value.

**Follow the steps below given**:-

- Enter the function in cell C11
- =NOT(B11), Press Enter

The function has returned TRUE, because any numeric value barring zero is considered as TRUE. And “0” or an empty cell are treated as FALSE, thus the function returns TRUE.

So, if you take “0” in the argument in cell C12 the function returns TRUE. But if we take the argument in decimals then it will give the result FALSE.

**When value is zero**:-

**When value in decimal**:-

So, this is how we can use NOT function in Microsoft Excel.

# Video: How to use NOT function in Microsoft Excel

Watch the steps in this short video, and the written instructions are above the video

*If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook. *

*We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com*