Logo Docs
Logo Docs

Operator <

Return TRUE if the left value is lesser than the one on the right, FALSE otherwise

Usage

left_value < right_value

Parameters

left_value

(Required) A number, date or text to compare
right_value

(Required) A number, date or text to compare

Examples

Example With these variables Result

price < 9.5
price is 9.5

FALSE

age1 < age2
age1 is 22
age2 is 25

TRUE

age1 < age2
age1 is 30
age2 is 25

FALSE

word1 < word2
word1 is "hello"
word2 is "world"

TRUE

date1 < date2
date1 is DATE(2022, 1, 2)
date2 is DATE(2022, 1, 2)

FALSE

date1 < date2
date1 is DATE(2022, 1, 1)
date2 is DATE(2022, 1, 2)

TRUE

date1 < date2
date1 is DATE(2022, 1, 2)
date2 is DATE(2022, 1, 1)

FALSE

More information

If the values are of different types, such as a text and a number, this function will report an error.

This operator is case insensitive, so “A” is considered equal to “a”. Use the EXACT function if you need case sensitivity.

Unlike Excel, this operator also runs TRIM on the texts it receives. With Word’s formatting, it’s quite easy to accidentally have double spaces or spaces between the quotes and the text. Using TRIM automatically means that "hello world" is considered equal to "  hello   world  ", but not to "helloworld". Use the EXACT function if you don’t want this automated TRIM.

See also