NOT function in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the NOT function do in Excel?

The NOT function reverses the logical value of its argument. If the input is TRUE, it returns FALSE; if the input is FALSE, it returns TRUE.

beginner

Write the formula to get the opposite of TRUE using the NOT function.

=NOT(TRUE) returns FALSE.

intermediate

How can NOT be used with a logical test like A1>10?

You can write =NOT(A1>10). It returns TRUE if A1 is NOT greater than 10, otherwise FALSE.

beginner

What will =NOT(5=5) return?

Since 5=5 is TRUE, =NOT(5=5) returns FALSE.

intermediate

Can the NOT function be used with non-logical values like numbers or text?

Yes, Excel treats non-zero numbers as TRUE and zero as FALSE. For example, =NOT(0) returns TRUE, and =NOT(1) returns FALSE. Text values cause an error unless they are logical TRUE or FALSE.

What does =NOT(FALSE) return?

A TRUE

B FALSE

C 0

D Error

NOT reverses FALSE to TRUE.

Which formula returns TRUE if cell A1 is NOT equal to 5?

A =A1=5

B =NOT(A1<>5)

C =NOT(A1>5)

D =NOT(A1=5)

The formula =NOT(A1=5) returns TRUE when A1 is not 5.

What will =NOT(10>20) return?

A TRUE

B FALSE

C 10

D 20

Since 10>20 is FALSE, NOT(FALSE) returns TRUE.

If =NOT(0) is entered, what is the result?

A FALSE

B TRUE

C 0

D Error

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

Which of these is NOT a valid use of the NOT function?

A Reversing a logical test result

B Checking if a number is zero

C Converting text to uppercase

D Negating TRUE or FALSE values

NOT does not change text case; it only reverses logical values.

Explain how the NOT function works and give an example of when you might use it in a spreadsheet.

Think about how to check the opposite of a condition.

Describe how Excel treats numbers when used inside the NOT function.

Consider how logical functions interpret numbers.