Use Excel's information functions in your Anaplan XL reports
| Function | Description |
| CELL | Returns information about a cell's location, formatting, or contents in the upper-left cell in a reference. |
| ERROR.TYPE | Returns the corresponding number value associated with an error type in Microsoft Excel. |
| INFO | Returns operating environment information. |
| ISBLANK | Returns TRUE if the cell is empty, FALSE if it contains data. |
| ISERR | Returns TRUE if value contains any error value except #N/A, FALSE if it does not. |
| ISERROR | Returns TRUE if value contains any error value (including #N/A), FALSE if it does not. |
| ISEVEN | Returns TRUE if value is an even number, FALSE if it is not. |
| ISFORMULA | Returns TRUE if the specified cell contains a formula. |
| ISLOGICAL | Returns TRUE if value is a logical value, FALSE if it is not. |
| ISNA | Returns TRUE if value is #N/A, FALSE if it is not. |
| ISNONTEXT | Returns TRUE if value is not text, FALSE if it is. |
| ISNUMBER | Returns TRUE if value is a number, FALSE if it is not. |
| ISODD | Returns TRUE if value is an odd number, FALSE if it is not. |
| ISREF | Returns TRUE if value is a reference, FALSE if it is not. |
| ISTEXT | Returns TRUE if value is text, FALSE if it is not. |
| N | Returns a value converted to a number. |
| NA | An alternative representation of the error value #N/A. |
| SHEET | Returns the one based index of the specified sheet, or the index of the sheet containing the formula if no sheet is specified. |
| SHEETS | Returns the number of sheets in a 3d cell reference, or the number of sheets in the workbook containing the formula if no reference is specified. |
| TYPE | Determines the type of value in a cell. |
