Information Functions

  • 2 minutes to read

This document describes information functions supported by the non-visual Spreadsheet component.

Name

Description

Syntax

CELL

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

CELL(info_type, [reference])

ERROR.TYPE

Returns a number corresponding to one of error values or returns #N/A if no error exists.

ERROR.TYPE(value)

INFO

Returns information about the current operating environment.

INFO(type_text)

ISBLANK

Checks whether a value refers to an empty cell.

ISBLANK(value)

ISERR

Checks whether a value or expression returns an error except #N/A.

ISERR(value)

ISERROR

Checks whether a value or expression returns any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!).

ISERROR(value)

ISEVEN

Checks whether the number is even.

ISEVEN(value)

ISFORMULA

Checks whether the referenced cell contains formula.

ISFORMULA(reference)

ISLOGICAL

Checks whether a value is a logical value.

ISLOGICAL(value)

ISNA

Checks whether a value or expression returns the #N/A error.

ISNA(value)

ISNONTEXT

Checks whether a value or expression is not text.

ISNONTEXT(value)

ISNUMBER

Checks whether a value or expression is a number.

ISNUMBER(value)

ISODD

Checks whether the number is odd.

ISODD(value)

ISREF

Checks whether a value is a reference.

ISREF(value)

ISTEXT

Checks whether a 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)

See Also