Logical Functions
Name | Description |
---|---|
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 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.