Returns whether the first value is equal to the second value. 2 = 32 = 3 returns FALSE, but 2 = 22 = 2 and "a" = "A""a" = "A" return TRUE. Text string comparisons are case-insensitive.

This operator also works with arrays. { 5, 7 } = 7{ 5; 7 } = 7 returns the array { FALSE, TRUE }{ FALSE; TRUE } (equivalent to { 5 = 7, 7 = 7 }{ 5 = 7; 7 = 7 }) and { 5, 7 } = { 5, 10 }{ 5; 7 } = { 5; 10 } returns the array { TRUE, FALSE }{ TRUE; FALSE } (equivalent to { 5 = 5, 7 = 10 }{ 5 = 5; 7 = 10 }).

Related operators and functions

The == operator is similar to this operator, but is case-sensitive and returns a single logical value when applied to arrays (see below for an example).

The EXACT function may be used to compare to text strings in a case-sensitive manner, like the == operator.

The first formula below returns TRUE and the remaining two formulas return FALSE:

FILTER, arrays and =

The logical arrays returned by this operator are especially useful with functions like FILTER, which takes an array and returns another array only containing certain elements.

This formula returns the array { 2 }{ 2 }:

4 is left out, because it is not equal to 2.

The formula above works because { 2, 4 } = 2{ 2; 4 } = 2 is expanded to the array { TRUE, FALSE }{ TRUE; FALSE } by the = operator. As such, the formula above is equivalent to this formula:

Determining if two arrays are identical

To determine if two arrays are identical to one another, = can be used together with the AND function. This formula returns TRUE:

The formula above works because { 2, 2 } = { 2, 2 }{ 2; 2 } = { 2; 2 } is expanded to the array { TRUE, TRUE }{ TRUE; TRUE } by the = operator. As such, the formula above is equivalent to this formula:

If the arrays are of different sizes, = returns errors for the missing elements, and so does AND. To handle arrays of any size, compare their sizes first. This formula returns TRUE if the arrays Array1 and Array2 are identical:

The == operator can also be used to determine if two arrays are identical, and handles arrays of different sizes. Unlike = , it compares text strings in a case-sensitive manner. This formula returns TRUE:

Records and tables

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

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

Tables are compared row by row, like arrays. TABLE (A: { 1, 2 }) = TABLE (A: { 1, 3 }) TABLE (A: { 1; 2 }) = TABLE (A: { 1; 3 }) returns the array { TRUE, FALSE }{ TRUE; FALSE }.