Returns 'TRUE' if the first argument is less than or equal to the second, and 'FALSE' otherwise. Equivalent to the '<=' operator.
Sample usage
LTE(A2,A3)
LTE(2,3)
Syntax
LTE(value1, value2)
-
value1
– The value to test as being less than or equal to value2. -
value2
– The second value.
See also
NE
: Returns 'TRUE' if two specified values are not equal, and 'FALSE' otherwise. Equivalent to the '<>' operator.
LT
: Returns 'TRUE' if the first argument is strictly less than 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.