Comparison Operators
|
Operator |
Description |
|---|---|
|
Equal to (3 = 3) |
|
|
Greater than (3 > 2) |
|
|
Greater than or equal to (3 >= 3) |
|
|
Less than (2 < 3) |
|
|
Less than or equal to (3 <= 3) |
|
|
Not equal to (3 <> 2) |
If a field included in an addition, subtraction, multiplication, division or comparison operation is empty or null, the value "0" (zero) is used for the field value. The following formula is an exception to this rule:
IF([Sample Field] = 0, "TRUE","FALSE")
In this formula, the Sample Field is not populated with the value "0" if the field is empty or null. Instead, this formula returns TRUE when the Sample Field is empty or null.
