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.) |