officefileapi-15497-spreadsheet-document-api-formulas-functions-information-functions.md
This document describes information functions supported by the non-visual Spreadsheet component.
|
Name
|
Description
|
Syntax
| | --- | --- | --- | |
|
Returns information about the formatting, location, or contents of a cell.
|
CELL(info_type, [reference])
| |
|
Returns a number corresponding to one of error values or returns #N/A if no error exists.
|
ERROR.TYPE(value)
| |
|
Returns information about the current operating environment.
|
INFO(type_text)
| |
|
Checks whether a value refers to an empty cell.
|
ISBLANK(value)
| |
|
Checks whether a value or expression returns an error except #N/A.
|
ISERR(value)
| |
|
Checks whether a value or expression returns any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!).
|
ISERROR(value)
| |
|
Checks whether the number is even.
|
ISEVEN(value)
| |
|
Checks whether the referenced cell contains formula.
|
ISFORMULA(reference)
| |
|
Checks whether a value is a logical value.
|
ISLOGICAL(value)
| |
|
Checks whether a value or expression returns the #N/A error.
|
ISNA(value)
| |
|
Checks whether a value or expression is not text.
|
ISNONTEXT(value)
| |
|
Checks whether a value or expression is a number.
|
ISNUMBER(value)
| |
|
Checks whether the number is odd.
|
ISODD(value)
| |
|
Checks whether a value is a reference.
|
ISREF(value)
| |
|
Checks whether a value or expression is text.
|
ISTEXT(value)
| |
|
Returns a value converted to a number.
|
N(value)
| |
|
Returns the error value #N/A.
|
NA()
| |
|
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.
| |
|
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.
| |
|
Returns the type of value.
|
TYPE(value)
|
See Also