Excel Logical Functions : NOT

Introduction to NOT Function

Logical functions in Excel are predefined formulas that evaluate a given condition or set of conditions and return a Boolean value (TRUE or FALSE) based on whether the condition is met or not. They are used to test the truth or falsehood of a statement or a condition, and to make decisions based on the result. In this blogpost, we will discuss about NOT Function in Excel.

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

Download Sample File

Download SAMPLE FILE to work, practice and master the LOGICAL Functions in Excel.

Syntax of NOT Function

NOT(logical)

Arguments of NOT Function

• 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 of NOT Function in MS Excel

Other Excel Logical Functions Tutorials

You can explore and master other Logical functions in Microsoft Excel. Here is a complete list of Logical functions available in Microsoft Excel.

• AND Function
• FALSE Function
• IF Function
• IFERROR Function
• IFNA Function
• NOT Function
• OR Function
• TRUE Function