Information Functions

• Sep 19, 2023
• 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)