|
ame
|
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)
|
|