Logical

Programmming Overview > Supported Formula Functions

For further informations about argument types, restrictions and return values please see Office Open XML File Formats - ISO/IEC 29500 - 1, Chapter: 18.17.7 Predefined Function Definitions.

Formula Description
AND(argument-list) Tests if all arguments in argument-list are TRUE. The function evaluates all arguments prior to returning a value.
FALSE() Computes the value FALSE. (A call to function FALSE is equivalent to using the logical-constant FALSE.)
IF(logical-value,[value-if-true][,[value-if-false]]) Tests logical-value, and if it is TRUE, value-if-true is evaluated and returned; otherwise, value-iffalse is evaluated and returned.
NOT(logical-value) Computes the logical negation of logical-value.
OR(argument-list) Tests if any one or more arguments in argument-list are TRUE. The function evaluates all arguments prior to returning a value.
TRUE() Computes the value TRUE. (A call to function TRUE is equivalent to using the logical-constant TRUE.)