how to use excel not function

Quick Intro

By using Excel Not Function you can reverse a logical value.

In simple words, It will convert TRUE to FALSE & FALSE To TRUE. If any formula results in a logical value or a cell has a logical value it will reverse that value. In the below example, we have converted logical value TRUE to FALSE by using NOT Function.

 

Defination for Excel NOT Function

Syntax

NOT(logical)

logical Value you want to test to reverse the logical value.

Additional Information on Excel NOT Function

  • If you refer to a blank cell it will treat that value as a TRUE.

Examples

In the below example, we have used numbers instead of logical values. As you know logical values have values in number.

You can also use NOT function with numbers as well. As 0 is equal to FALSE, NOT has converted it into TRUE. And, any number other than 0 will be treated as TRUE & converted into FALSE.

Examples For Excel NOT Function With Numbers

In the below example, we have used NOT Function with formulas. While comparing values from two cells I have reversed the logical results. You can use this function where you need to reverse the logical value.

Examples For Excel NOT Function With Formulas

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel NOT Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There are also you have OR | AND functions which are highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.