NOT Function

NOT:-  NOT returns opposite of given logical or Boolean value. When given TRUE, NOT returns FALSE.

Why do we want to get such a ridiculous result? In certain cases, we might be more interested to know when a certain condition is not met. In that case, we can use NOT function.

NOT Function Syntax:



Logical:  A value or logical expression that can be evaluated as TRUE or FALSE.

Tutorial of NOT function in Excel


In the above example, we don’t want to select any item having Yellow color. For that, we can use NOT function in the D column.

IF we want to test several conditions in the single formula we can use NOT function in conjunction with AND or OR function. For example, if we want to exclude two colors Yellow and Orange we can use NOT function along with OR.

NOT FUNCTION in conjunction with OR Function:

Let’s consider we need to exclude Orange and Yellow colors.

NOT FUNCTION conjunction with AND Function:

Same way let’s consider we need to exclude Yellow color in Sleepwear only. For that, We will use NOT function in conjunction with AND.

The result is C29 with FALSE as we do not want to exclude sleepwear & Yellow color.

Recommended For You

About the Author: Mehul Vaghela

Howdy Math fan. I'm Mehul Vaghela - B.E.Mechanical. Enthusiastic and holds the passion of reading, writing, and learning. In 10 years of experience on the field, I've faced so much problem with managing data and learned to make that happen. ExcelElixir is one of the parts of passing it on (knowledge).

Leave a Reply

Your email address will not be published. Required fields are marked *