What is EXCEL NOT FUNCTION
The Excel NOT Function is listed under Microsoft Excel's Logical Functions category. It returns the reversed logical value in the result. In simple words, you have a logical value that returns TRUE, NOT can convert it into FALSE and if you have a logical value which returns FALSE, NOT function will convert it into TRUE.
How to use it
To learn how to use the NOT function in Excel, you need to understand its syntax and arguments:
- logical: The value you want to test to reverse the logical value.
- If you refer to a blank cell it will treat that value as a TRUE
To master the NOT function we need to try it out in an example and below is one which you can try out:
In the below example, we have used NOT to reverse the logical results
This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:
About the Author
Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.