Information

Built-in functions › Spreadsheet formulas › Information

17 functions in this category.

Function	What it does
`cell`	Information about formatting, location, or contents of a cell.
`errortype`	Numeric code identifying an error.
`info`	Information about the current operating environment.
`isblank`	Test whether a cell is blank.
`iserr`	Test for any error except `#N/A`.
`iserror`	Test whether a value is any error.
`iseven`	Test whether a number is even.
`isna`	Test whether a value is `#N/A`.
`isnontext`	Test whether a value is not text.
`isodd`	Test whether a number is odd.
`isref`	Test whether a value is a cell reference.
`istext`	Test whether a value is text.
`n`	Convert a value to a number; non-numeric becomes 0.
`na`	Return the `#N/A` error value.
`sheet`	Sheet number of a reference.
`sheets`	Number of sheets in a workbook or reference.
`type`	Numeric code identifying the type of a value.