NOT function in Excel - Step-by-Step Guide

Introduction

The NOT function reverses the result of a logical test. If the test is TRUE, NOT returns FALSE. If the test is FALSE, NOT returns TRUE. This helps when you want to check the opposite of a condition.

When you want to find cells that do NOT meet a certain condition, like values not equal to 10.

When you want to filter data to exclude certain items, such as excluding completed tasks.

When you want to create a formula that triggers an action only if a condition is false.

When you want to combine with other logical functions to build complex conditions.

When you want to highlight or count items that do not match a specific rule.

Steps

Step 1: Click

- a blank cell where you want the result

The cell is selected and ready for input

Step 2: Type

- the formula bar

The formula starts appearing in the cell

💡 Start with an equal sign (=) to begin the formula

Step 3: Enter

- the formula: =NOT(logical_test)

The formula is entered, showing TRUE or FALSE based on the test

Step 4: Replace

- logical_test inside the formula

The formula checks your specific condition

💡 For example, use =NOT(A1=10) to check if A1 is not 10

Step 5: Press

- Enter key

The cell shows TRUE if the condition is false, or FALSE if the condition is true

Before vs After

Before

Cell A1 contains 10, formula =NOT(A1=10) is not entered

After

Cell with formula =NOT(A1=10) shows FALSE because A1 equals 10

Settings Reference

logical_test

📍 inside the NOT function parentheses

The condition you want to reverse

Default: none

Common Mistakes

Using NOT without a logical test, like =NOT()

NOT needs a condition to check; empty parentheses cause an error

Always include a logical test inside the parentheses, e.g., =NOT(A1=5)

Confusing NOT with other functions like IF

NOT only reverses TRUE/FALSE; it does not perform actions like IF

Use NOT to reverse conditions, and IF to decide actions based on conditions

Summary

The NOT function reverses TRUE to FALSE and FALSE to TRUE.

Use NOT to check the opposite of any condition.

Always include a logical test inside the NOT function.

Practice

1. What does the Excel function NOT(TRUE) return?

easy

A. FALSE

B. TRUE

C. 0

D. 1

Solution

1. Step 1: Understand the NOT function behavior

   The NOT function reverses the logical value it receives. If the input is TRUE, it returns FALSE.

2. Step 2: Apply NOT to TRUE

   Applying NOT to TRUE gives FALSE.

3. Final Answer:

   FALSE -> Option A

4. Quick Check:

   NOT(TRUE) = FALSE [OK]

Hint: NOT flips TRUE to FALSE and vice versa [OK]

Common Mistakes:

• Thinking NOT(TRUE) returns TRUE
• Confusing TRUE/FALSE with 1/0
• Using NOT without parentheses

2. Which of the following is the correct syntax to use the NOT function in Excel?

easy

A. NOT(A1=10)

B. NOT A1=10

C. NOT(A1=10

D. NOT[A1=10]

Solution

1. Step 1: Recall Excel function syntax

   Excel functions require the function name followed by parentheses enclosing the argument.

2. Step 2: Check each option

   NOT(A1=10) uses correct syntax: NOT(A1=10). Options A, B, and D have missing or wrong parentheses or brackets.

3. Final Answer:

   NOT(A1=10) -> Option A

4. Quick Check:

   Correct syntax uses parentheses [OK]

Hint: Always use parentheses with Excel functions [OK]

Common Mistakes:

• Omitting parentheses
• Using square brackets instead of parentheses
• Placing NOT outside the parentheses incorrectly

3. Given cell A1 contains the value 5, what is the result of the formula =NOT(A1>10)?

medium

A. FALSE

B. TRUE

C. 5

D. 10

Solution

1. Step 1: Evaluate the condition inside NOT

   The condition A1>10 checks if 5 is greater than 10, which is FALSE.

2. Step 2: Apply NOT to the condition result

   NOT(FALSE) reverses FALSE to TRUE.

3. Final Answer:

   TRUE -> Option B

4. Quick Check:

   NOT(FALSE) = TRUE [OK]

Hint: Evaluate inside condition first, then flip with NOT [OK]

Common Mistakes:

• Assuming 5 > 10 is TRUE
• Forgetting NOT reverses the result
• Confusing cell value with formula result

4. The formula =NOT(A1=5 is entered in a cell. What is the issue with this formula?

medium

A. Incorrect use of NOT function

B. A1 cannot be compared to 5

C. Missing closing parenthesis

D. NOT function does not accept logical expressions

Solution

1. Step 1: Check formula syntax

   The formula has an opening parenthesis after NOT but no closing parenthesis.

2. Step 2: Identify the error

   Excel requires matching parentheses for functions. Missing closing parenthesis causes a syntax error.

3. Final Answer:

   Missing closing parenthesis -> Option C

4. Quick Check:

   All functions need matching parentheses [OK]

Hint: Count your parentheses carefully [OK]

Common Mistakes:

• Forgetting to close parentheses
• Misplacing parentheses around arguments
• Thinking NOT can't use logical tests

5. You want to highlight cells in column A that do NOT equal "Complete" using conditional formatting. Which formula should you use?

hard

A. =NOT("Complete"=A1

B. =NOT(A1=Complete)

C. =NOT(A1, "Complete")

D. =NOT(A1="Complete")

Solution

1. Step 1: Understand the condition to check

   You want to check if the cell text is NOT equal to "Complete".

2. Step 2: Write the correct NOT formula

   The correct syntax is NOT(A1="Complete") which returns TRUE when A1 is not "Complete".

3. Step 3: Check other options

   =NOT("Complete"=A1) misses closing parenthesis, causing syntax error. =NOT(A1=Complete) misses quotes around text, causing error. =NOT(A1, "Complete") uses wrong syntax with comma.

4. Final Answer:

   =NOT(A1="Complete") -> Option D

5. Quick Check:

   Use NOT with logical test inside parentheses [OK]

Hint: Put logical test inside NOT parentheses with quotes for text [OK]

Common Mistakes:

• Omitting quotes around text
• Using comma inside NOT
• Missing closing parenthesis