Simple inequality operator

Value1 != Value2 Value1 != Value2

Value1

The first value to compare.

Value2

The second value to compare.

Returns

Logical Logical

Whether the first value is not equal to the second value.

Returns whether the first value is not equal to the second value. 2 != 32 != 3 returns TRUE, but 2 != 22 != 2 returns FALSE. "a" != "A""a" != "A" returns TRUE, because text string comparisons are case-sensitive (unlike the <> operator, where text string comparisons are case-insensitive.)

Array behavior

When applied to arrays, this operator returns a single TRUE or FALSE value indicating whether their elements are not identical.

This formula returns FALSE:

{ 2, 2 } != { 2, 2 }

{ 2; 2 } != { 2; 2 }

This formula returns TRUE:

{ 2, 2 } != { 2, 3 }

{ 2; 2 } != { 2; 3 }

The <> operator works differently. This formula returns the array { FALSE, FALSE }{ FALSE; FALSE }:

{ 2, 2 } <> { 2, 2 }

{ 2; 2 } <> { 2; 2 }

This formula returns the array { FALSE, TRUE }{ FALSE; TRUE }:

{ 2, 2 } <> { 2, 3 }

{ 2; 2 } <> { 2; 3 }

The behavior of the <> operator is useful particularly when used with the FILTER function. Refer to the <> documentation for more information.

Records and tables

Two records are not equal if any of their members of the same name are not equal. The order of the members does not matter. Text strings in the members are compared in a case-sensitive manner.

RECORD (A: "a") != RECORD (A: "A") RECORD (A: "a") != RECORD (A: "A") returns TRUE, but RECORD (A: 1, B: 2) != RECORD (B: 2, A: 1) RECORD (A: 1; B: 2) != RECORD (B: 2; A: 1) returns FALSE.

Like arrays, two tables are compared as a whole, and the result is a single TRUE or FALSE value. TABLE (A: { 1, 2 }) != TABLE (A: { 1, 3 }) TABLE (A: { 1; 2 }) != TABLE (A: { 1; 3 }) returns TRUE.

Examples

2 != 3

Returns TRUE.

2 != 2

Returns FALSE.

"a" != "A"

Returns TRUE. Text string comparisons are case-sensitive.

"a" <> "A"

Returns FALSE, as the <> operator compares text strings in a case-insensitive manner.

"a" != "a"

Returns FALSE. Text string comparisons are case-sensitive.

{ 2, 2 } != { 2, 2 }

{ 2; 2 } != { 2; 2 }

Returns FALSE, because all pairs in the two arrays are equal to one another.

{ 2, 2 } != { 2, 3 }

{ 2; 2 } != { 2; 3 }

Returns TRUE, because not all pairs in the two arrays are equal to one another.