Excel NOT Function

HomeExcel FunctionsExcel NOT Function (Example + Sample File)

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: 

Syntax

NOT(logical)

Arguments

  • logical: The value you want to test to reverse the logical value.

Notes

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

Example

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

Related functions

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 Gogia

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 find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.