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.