NOT function in Excel

Hello all. In this short section, let’s look at NOT function. NOT is a logical function that returns the opposite of logical / boolean value.

Syntax:

=NOT(logical)

Let’s look at a simple example. In the given data set, we are returning TRUE for color Black in the if logic. However, when used NOT with the IF, it would return the reverse value.

A very good use case is using NOT with ISBLANK() logic as Excel doesn’t have IS NOT Blank as a built in logic.

I hope you liked this short tutorial. Please let us know your feedback which would help to improve the content. Thanks for reading.

One thought on “NOT function in Excel

Leave a Reply

%d bloggers like this: