Information Functions

• Jul 27, 2021
• 2 minutes to read

This document briefly describes information functions implemented in the ASPxSpreadsheet.

CELL(info_type, [reference])

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

ERROR.TYPE(value)

Returns a number corresponding to one of the error values.

INFO(type_text)

Returns information about the current operating environment.

ISBLANK(value)

Tests if the value is a reference to an empty cell.

ISERR(value)

Tests if the value or expression returns an error.

ISERROR(value)

Tests if the value or expression returns an error, except for the #N/A error.

ISEVEN(value)

Tests if the number is even.

ISFORMULA(reference)

Tests if the refrenced cell contains formula.

ISLOGICAL(value)

Tests if the value is a logical value.

ISNA(value)

Tests if the value or expression returns the #N/A error.

ISNONTEXT(value)

Tests if the value or expression is text.

ISNUMBER(value)

Tests if the value or expression is a number.

ISODD(value)

Tests if the number is odd.

ISREF(value)

Tests if the value is a reference.

ISTEXT(value)

Tests if the value or expression is text.

N(value)

Returns a value converted to a number.

NA()

Returns the error value #N/A.

SHEET(value)

Returns the sheet number of the referenced sheet.

The value parameter is optional. It is the name of a sheet or a reference for which to obtain the sheet number. If the value is omitted, the number of the sheet that contains the function is returned.

SHEETS(reference)

Returns the number of sheets in a reference.

The reference parameter is optional. If the parameter is omitted, the number of sheets in the workbook that contains the function is returned.

TYPE(value)

Returns the type of value.