Logic operators

Reference for all logic and comparison operators supported in Noloco formula fields, including IF, AND, OR, NOT, TRUE, FALSE, NULL, ISNUMBER, and the comparison operators <, >, =. NULL, TRUE, and FALS

All logic and comparison operators supported in Noloco formulas. Use these for conditional values, boolean composition, and value comparisons.

Available operators: <, >, =, AND, OR, NOT, IF, TRUE, FALSE, NULL, ISNUMBER.

---

<

value1 < value2

Returns true if the first value is less than the second.

Example: 1 < 2

>

value1 > value2

Returns true if the first value is greater than the second.

Example: 1 > 2

=

value1 = value2

Returns true if the first value equals the second.

Example: 1 = 2

AND

AND(logicValue, logicValue, ...)

Returns true if all arguments are true.

OR

OR(logicValue, logicValue, ...)

Returns true if any argument is true.

NOT

NOT(logicValue)

Returns the opposite of a logical value.

Example: NOT(TRUE()) returns FALSE()

IF

IF(logicValue, trueValue, falseValue)

Returns one value when a condition is true, and another when it is false.

TRUE

TRUE()

Returns the value true.

FALSE

FALSE()

Returns the value false.

NULL

NULL()

Returns the value null.

Must be called as NULL() with parentheses. Writing NULL (without parentheses) is not valid and will cause the formula to fail. The same applies to TRUE() and FALSE().

ISNUMBER

ISNUMBER(value)

Returns true if the argument is a number.

---

Related

• Formulas overview

• Examples — see "Joining text fields" for an IF/OR/ISBLANK pattern

• Date & time operators

• Math operators

• Text operators