Information Functions

The following table lists information functions that are supported in TM1 Web.

Function

Description

CELL

Returns information about the formatting, location, or contents of a cell.

Support for the Cell function is limited to the following info_types: address, col, row, protect, contents, type.

ISBLANK

Returns TRUE if the value is blank.

ISERR

Returns TRUE if the value is any error value except #N/A.

ISERROR

Returns TRUE if the value is any error value.

ISNA

Returns TRUE if the value is the #N/A error value.

ISNUMBER

Returns TRUE if the value is a number.

N

Returns a value converted to a number.

NA

Returns the error value #N/A.