Use Excel's logical functions in your Anaplan XL reports.
Function | Description |
AND | Returns TRUE if all the arguments are TRUE in the formula, and FALSE if any one argument is FALSE. |
FALSE | Returns the value FALSE. May be typed directly into the cell as "FALSE". |
IF | Returns a value if one condition is TRUE and returns another value if the condition is FALSE. |
IFERROR | Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula |
IFNA | Returns the specified first argument unless it is #N/A, in which case it returns the specified second argument. |
NOT | Returns the reverse value of its arguments; TRUE becomes FALSE and FALSE becomes TRUE. |
OR | Returns FALSE if all arguments are FALSE, and TRUE if at least one argument is TRUE. |
TRUE | Returns the value TRUE. May be typed directly into the cell as "TRUE". |
XOR | Returns TRUE if the specified arguments contain an odd number of TRUE values, or FALSE if the values contain an even number of TRUE values. |