Logical
Logical functions let a table cell formula in TXTextControl test conditions and choose a result: IF returns one of two values, AND, OR and NOT combine and negate logical values, and TRUE and FALSE return the logical constants.
Argument types, restrictions and return values of each function are defined in Office Open XML File Formats, ISO/IEC 29500-1, chapter 18.17.7 Predefined Function Definitions.
Logical Functions
| Function | 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-if-false 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.) |