NOT function

NOT (Value) NOT (Value)

Value

Logical Logical

The value to check.

Returns

Logical Logical

TRUE if the parameter is FALSE and FALSE otherwise.

Negates the logical parameter and returns it. NOT (TRUE) NOT (TRUE) returns FALSE and NOT (FALSE) NOT (FALSE) returns TRUE.

Use NOT, AND, OR and XOR in conjunction with IF to express logical conditions.

This formula returns 2 only if Value1 is 20 and Value2 is not 40, and 4 otherwise:

IF ( AND (Value1 = 20, NOT (Value2 = 40)), 2, 4)

IF ( AND (Value1 = 20; NOT (Value2 = 40)); 2; 4)

The formula can also be written using the && and ! operators (which are not commonly supported by spreadsheets):

IF ((Value1 = 20) && ! (Value2 = 40), 2, 4)

IF ((Value1 = 20) && ! (Value2 = 40); 2; 4)

&& is written between the values to test, instead of before them, which can make formulas easier to read.

To make the formula even easier to read, consider replacing the second = operator with either the <> operator or the != operator (which mean "not equal to"):

IF ((Value1 = 20) && (Value2 <> 40), 2, 4)

IF ((Value1 = 20) && (Value2 <> 40); 2; 4)

Examples

IF ( AND (Value1 = 20, NOT (Value2 = 40)), 2, 4)

IF ( AND (Value1 = 20; NOT (Value2 = 40)); 2; 4)

Returns 2 only if Value1 is 20 and Value2 is not 40. Otherwise, 4 is returned.

IF ((Value1 = 20) && ! (Value2 = 40), 2, 4)

IF ((Value1 = 20) && ! (Value2 = 40); 2; 4)

Returns 2 only if Value1 is 20 and Value2 is not 40. Otherwise, 4 is returned. This example uses the && and ! operators, which are not commonly supported by spreadsheets, instead of the AND and NOT functions.

IF ((Value1 = 20) && (Value2 != 40), 2, 4)

IF ((Value1 = 20) && (Value2 != 40); 2; 4)

Returns 2 only if Value1 is 20 and Value2 is not 40. Otherwise, 4 is returned. This example uses the != operator (inequality) instead of the = operator (equality), fully replacing the ! operator and the NOT function. In this context, the != and <> operators are equivalent.

NOT ({ TRUE, FALSE, TRUE, FALSE })

NOT ({ TRUE; FALSE; TRUE; FALSE })

Returns { FALSE, TRUE, FALSE, TRUE }{ FALSE; TRUE; FALSE; TRUE }, a negated version of the given array.