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