GREATER OR EQUAL (>=)

Description

The GREATER OR EQUAL (>=) operator tests where one value is greater or equal to another value.

Usage

a >= b

Remarks

The value of the expression is TRUE if a is greater than or equal to b.

Generally, a and b must have the same type. That is, a and b must both be numbers, or text, or dates. However, if either a or b are of different types, but one is text, then the other will be implicitly converted to text using the same conventions as the TEXT function.

When comparing text, the comparison is case sensitive. That means that "ABC" does not equal "abc".

Examples

Check if a respondent is an adult

If you have a quantity field collecting AGE, you cn determine whether the respondent is an adult with the following formula:

AGE >= 18

Compare text

You could use formulas to split participants into three groups based on their LAST_NAME:

IF(LAST_NAME >= "Q", "Third wave", IF(LAST_NAME >= "M", "Second wave", "First wave"))

Validate a date range

When collecting dates, you may want to ensure that they fall into a specific date range, for example between January 2022 and July 2023.

TRAINING_DATE >= DATE(2022,1,1) && TRAINING_DATE <= DATE(2023,7,31)
Next item
TEXT