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.

ISNUMBER

ISNUMBER(value)

Returns true if the argument is a number.


Last updated

Was this helpful?