# How to use NOT function in Microsoft Excel

http://www.exceltip.com/logical/excel-not-function.html

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:

1st Example:-

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

• 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

2nd 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.

3rd Example:-

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

• 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.

4th Example:-

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

• 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