Logical

AND

The AND function is a logical function in the formula editor, used to return TRUE if all provided conditions are true.

Syntax: AND(Condition1, Condition2, ...)

Condition1, Condition2, ...: Logical expressions to evaluate.

Mandatory: At least one condition. Optional: Additional conditions.

Example: Let's say you want to check if two conditions are both true:

AND(true, false)

The function will return false.

IF

The IF function returns one value if a condition is true, and another if it is false.

Syntax: IF(Condition, ValueIfTrue, ValueIfFalse)

Condition: The logical test. ValueIfTrue: The value to return if true. ValueIfFalse (optional): The value to return if false.

Example: IF(5 > 3, "yes", "no") The function will return "yes".

ISNULL

The ISNULL function checks if a value is null or empty.

Syntax: ISNULL(Value)

Value: The value to check.

Example: ISNULL(null) The function will return true.

NOT

The NOT function returns the logical negation of a condition.

Syntax: NOT(Condition)

Condition: The logical expression.

Example: NOT(true) The function will return false.

OR

The OR function returns TRUE if any of the provided conditions are true.

Syntax: OR(Condition1, Condition2, ...)

Condition1, Condition2, ...: Logical expressions to evaluate.

Mandatory: At least one condition Optional: Additional conditions

Example: OR(false, false, true) The function will return true.