NOT

Reverse the logical value of the argument in Excel
Reverses the logic of its argument

Rational

Reverse the logical value of the argument.

Description

The Excel NOT function reverse a boolean result (TRUE or FALSE) of logical criteria in the argument. For example, =NOT(5=5) although the logical test is true the function return FALSE (reverse the result).

Syntax

=NOT(logical)

Parameters

logical – A criterion in the argument with TRUE and FALSE value

Return Value

Reverse the Boolean return value

Key Notes

  • The Excel NOT function reverse a logical value by switching ‘true to false’ or ‘false to true’.
  • NOT function clubbed with IF function can test many different conditions at once.

Keep Reading Similar Functions:

Return the logical value FALSE in Excel

FALSE

The FALSE function returns the logical value FALSE. The formula is useful to enter the FALSE directly into the cell or added as part of criteria.

Read More »
Retrun the logical value TRUE in Excel

TRUE

The TRUE function returns the logical value ‘TRUE’. The formula is useful to enter the TRUE directly into the cell or added as part of criteria in a formula.

Read More »