21.1 (EAP/Beta)
20.2
20.1
19.2
19.1
18.2
18.1
17.2
A newer version of this page is available. Switch to the current version.

# Information Functions

• 2 minutes to read

This document briefly describes information functions implemented in the XtraSpreadsheet.

Name

Description

Syntax

CELL

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

CELL(info_type, [reference])

ERROR.TYPE

Returns a number corresponding to one of the error values.

ERROR.TYPE(value)

INFO

Returns information about the current operating environment.

INFO(type_text)

ISBLANK

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

ISBLANK(value)

ISERR

Tests if the value or expression returns an error.

ISERR(value)

ISERROR

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

ISERROR(value)

ISEVEN

Tests if the number is even.

ISEVEN(value)

ISFORMULA

Tests if the refrenced cell contains formula.

ISFORMULA(reference)

ISLOGICAL

Tests if the value is a logical value.

ISLOGICAL(value)

ISNA

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

ISNA(value)

ISNONTEXT

Tests if the value or expression is text.

ISNONTEXT(value)

ISNUMBER

Tests if the value or expression is a number.

ISNUMBER(value)

ISODD

Tests if the number is odd.

ISODD(value)

ISREF

Tests if the value is a reference.

ISREF(value)

ISTEXT

Tests if the value or expression is text.

ISTEXT(value)

N

Returns a value converted to a number.

N(value)

NA

Returns the error value #N/A.

NA()

SHEET

Returns the sheet number of the referenced sheet.

SHEET(value)

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

Returns the number of sheets in a reference.

SHEETS(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

Returns the type of value.

TYPE(value)