Returns TRUE if the first argument is strictly less than the second, and FALSE otherwise. Equivalent to the < operator.

Sample Usage

LT(A2,A3)

LT(2,3)

Syntax

LT(value1, value2)

  • value1 - The value to test as being less than value2.
  • value2 - The second value.

See Also

NE: Returns “TRUE” if two specified values are not equal and “FALSE” otherwise. Equivalent to the ”<>” operator.

LTE: Returns TRUE if the first argument is less than or equal to the second, and FALSE otherwise. Equivalent to the <= operator.

GTE: Returns TRUE if the first argument is greater than or equal to the second, and FALSE otherwise. Equivalent to the >= operator.

GT: Returns TRUE if the first argument is strictly greater than the second, and FALSE otherwise. Equivalent to the > operator.

EQ: Returns “TRUE” if two specified values are equal and “FALSE” otherwise. Equivalent to the ”=” operator.

Examples