Use Excel's logical functions in your Anaplan XL reports.

FunctionDescription
ANDReturns TRUE if all the arguments are TRUE in the formula, and FALSE if any one argument is FALSE.
FALSEReturns the value FALSE. May be typed directly into the cell as "FALSE".
IFReturns a value if one condition is TRUE and returns another value if the condition is FALSE.
IFERRORReturns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
IFNAReturns the specified first argument unless it is #N/A, in which case it returns the specified second argument.
NOTReturns the reverse value of its arguments; TRUE becomes FALSE and FALSE becomes TRUE.
ORReturns FALSE if all arguments are FALSE, and TRUE if at least one argument is TRUE.
TRUEReturns the value TRUE. May be typed directly into the cell as "TRUE".
XORReturns TRUE if the specified arguments contain an odd number of TRUE values, or FALSE if the values contain an even number of TRUE values.