How to use NOT function in Microsoft Excel

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/logical/excel-not-function.html
SHARE




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.

image 1

 

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:

image 2

 

1st Example:-

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

image 3

 

Follow the steps given below:-

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

image 4

 

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

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

image 5

 

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:-

image 6

 

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

image 7

 

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.

image 8

 

Follow the steps given below:-

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

image 9

 

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.

image 10

 

Follow the steps below given:-

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

image 11

 

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:-

image 12

 

When value in decimal:-

image 13

 

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

 

image 48

 

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 [email protected]

Please follow and like us:
0


Leave a Reply

Your email address will not be published. Required fields are marked *

To avoid automated spam,Please enter the value *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>