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.