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