How to Use the NOT Function in Excel

The NOT function in Excel reverses a logical value. If something evaluates to TRUE, the NOT function changes it to FALSE. If something evaluates to FALSE, it changes it to TRUE. This makes NOT especially useful for reversing conditions in formulas, checking exceptions, and building more advanced logical tests alongside functions like IF, AND, and OR.

In This Guide, You’ll Learn

• What the NOT function does in Excel
• The syntax and argument of the NOT function
• How to reverse TRUE/FALSE results
• How to use NOT with logical tests
• How to combine NOT with IF and AND formulas
• Real-world uses for the NOT function in business spreadsheets

What is the NOT Function?

The NOT function reverses a logical result.

If a condition evaluates to TRUE, NOT changes it to FALSE. If a condition evaluates to FALSE, NOT changes it to TRUE.

This is useful when you want Excel to check whether something is not true rather than true.

For example:

• Is a value not greater than 100?
• Is a product not out of stock?
• Is an employee not eligible?

Instead of rewriting the entire condition, you can simply wrap it inside the NOT function.

NOT Function Syntax

=NOT(logical)

Argument Definitions

• logical — The logical value or condition you want to reverse

Example Dataset Used in This Tutorial

You can download the sample data we’ll be using in this tutorial by clicking on this link—> NOT Function Data

Reverse a TRUE or FALSE Value

In this example, we will use the NOT function to reverse basic logical values.

Formula

=NOT(A2)

Check If a Value Is NOT Greater Than a Number

You can use NOT to reverse comparison tests.

In this example, we will check whether sales values are not greater than 100.

Formula

=NOT(A2>100)

How It Works

• A2>100 checks if the value is greater than 100
• NOT reverses the result

So:

• Greater than 100 → FALSE
• 100 or less → TRUE

Result

This formula helps identify values that do not exceed a threshold.

Use NOT with the IF Function

The NOT function becomes much more useful when combined with IF.

Suppose employees must work at least 40 hours to qualify for overtime eligibility.

Formula

=IF(NOT(A2>=40),"Not Eligible","Eligible")

How It Works

First Excel checks:

A2>=40

Then:

• TRUE becomes FALSE
• FALSE becomes TRUE

If the employee did not work 40 hours or more, Excel returns:

Not Eligible

Otherwise:

Eligible

Result

This is a practical way to reverse eligibility conditions without rewriting logic.

Use NOT with OR

You can combine NOT with OR to reverse multiple conditions at once.

Suppose a store considers products available unless they are either Out of Stock or Discontinued.

Formula

=NOT(OR(A2="Out of Stock",A2="Discontinued"))

How It Works

The OR function checks if the product is:

• Out of Stock
• Discontinued

If either condition is TRUE, OR returns TRUE.

Then NOT reverses it:

• TRUE → FALSE
• FALSE → TRUE

Result

This formula is useful for excluding multiple unwanted conditions.

Use NOT with AND

You can also reverse AND logic.

Suppose a customer qualifies for a promotion only if:

• Purchase amount is over $100
• Membership status is YES

We can use NOT to identify customers who do not qualify.

Formula

=NOT(AND(A2>100,B2="Yes"))

How It Works

The AND function checks:

1. Purchase exceeds $100
2. Customer is a member

If both are TRUE:

TRUE

Then NOT reverses it:

FALSE

Meaning the customer does qualify, so they are not disqualified.

Result

This formula helps identify exceptions to business rules.

Common NOT Function Mistakes

Forgetting That NOT Reverses Logic

Remember:

• TRUE becomes FALSE
• FALSE becomes TRUE

If your results seem backwards, that may be intentional.

Using NOT Without a Logical Test

This works:

=NOT(A2>10)

This does not work well:

=NOT(100)

The NOT function expects a logical result.

Overcomplicating Conditions

Sometimes it is easier to write:

=A2<=100

Instead of:

=NOT(A2>100)

However, NOT becomes very useful inside larger formulas.

Example Dataset Used in This Tutorial

You can download the sample data we’ll be using in this tutorial by clicking on this link—> NOT Function Data

Related Articles