NOT function in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

📊 Formula Result

intermediate

Output of NOT function with TRUE input

What is the output of the formula =NOT(TRUE) in Excel?

Excel

=NOT(TRUE)

A 0

B FALSE

C TRUE

D 1

💡 Hint

The NOT function reverses the logical value.

NOT(TRUE) returns FALSE because NOT reverses TRUE to FALSE.

📊 Formula Result

intermediate

NOT function with a logical expression

What is the result of =NOT(5 > 10) in Excel?

Excel

=NOT(5 > 10)

A TRUE

B FALSE

C 5

D 10

💡 Hint

Check the logical expression inside the NOT function first.

5 > 10 is FALSE, so NOT(FALSE) returns TRUE.

❓ Function Choice

advanced

Choose the formula that returns TRUE only if A1 is NOT empty

Which formula returns TRUE only when cell A1 is NOT empty?

A =NOT(A1)

B =NOT(A1="")

C =ISBLANK(NOT(A1))

D =NOT(ISBLANK(A1))

💡 Hint

Think about how to check if a cell is empty and then reverse that.

ISBLANK(A1) is TRUE if A1 is empty. NOT(ISBLANK(A1)) is TRUE if A1 is NOT empty.
Option D returns TRUE if A1 is empty (wrong). Option D is invalid usage. Option D causes error if A1 is text.

📊 Formula Result

advanced

Output of NOT with a number input

What is the output of =NOT(0) in Excel?

Excel

=NOT(0)

A TRUE

B FALSE

C 0

D #VALUE!

💡 Hint

Remember how Excel treats 0 and non-zero numbers in logical functions.

Excel treats 0 as FALSE, so NOT(0) returns TRUE.

🎯 Scenario

expert

Using NOT to filter data in a formula

You want to count how many cells in range B1:B10 are NOT equal to "Completed". Which formula correctly does this?

A =COUNTIF(B1:B10, "Completed") - NOT(TRUE)

B =COUNTIF(B1:B10, NOT("Completed"))

C =COUNTIF(B1:B10, "<>Completed")

D =COUNTIF(B1:B10, "=NOT(Completed)")

💡 Hint

Think about how to write a condition for 'not equal to' in COUNTIF.

Option C uses the correct syntax "<>Completed" to count cells not equal to "Completed".
Option C is invalid because NOT cannot be used inside COUNTIF criteria like that.
Option C treats NOT as text, so it won't work.
Option C is incorrect logic and will not count correctly.

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