Skip to main content

Use of comparison operators

Array formulas support the use of comparison operators "=", "<>", ">", "<", ">=", "<=":

  • For an element-by-element comparison. Example: A1:A3 > B1:B3 → {A1>B1; A2>B2; A3>B3}.
  • To compare an array with a scalar. Example: A1:A5 > 10 → {A1>10; ...; A5>10}.

The result of calculating arrays using comparison operators will be an array with values of logical type (TRUE/FALSE).

If arrays contain data of different types, they are compared by type priority: Error > Logical > String > Number > Empty> Negative number.