Skip to content

Logical Functions

NameDescription
value_1 = value_2Equal.
value_1 <> value_2Not equal.
value_1 > value_2Greater than.
value_1 < value_2Less than.
value_1 >= value_2Greater than or equal.
value_1 <= value_2Less than or equal.
AND(logical_expression1, [logical_expression2, ...])Logical AND of expressions.
IF(logical_expression, value_if_true, value_if_false)Returns value depending on logical expression.
ISBLANK(value)Whether the value is empty (aka null).
NOT(logical_expression)Opposite of logical expression.
OR(logical_expression1, [logical_expression2, ...])Logical OR of expressions.

Details

value_1 = value_2

Equal.


value_1 <> value_2

Not equal.


value_1 > value_2

Greater than.


value_1 < value_2

Less than.


value_1 >= value_2

Greater than or equal.


value_1 <= value_2

Less than or equal.


AND(logical_expression1, [logical_expression2, ...])

Logical AND of expression.


IF(logical_expression, value_if_true, value_if_false)

Returns value depending on logical expression.


ISBLANK(value)

Whether the value is empty (aka null).


NOT(logical_expression)

Opposite of logical expression.


OR(logical_expression1, [logical_expression2, ...])

Logical OR of expressions.