ℹ️
Information Functions
9 functionsCheck cell types, errors, and metadata about your data
CELL
Returns information about a cell (address, contents, format, etc.).
ERROR.TYPE
Returns a number code for an error type.
ISBLANK
Tests whether a cell is truly empty.
ISERROR
Tests whether a value is any error.
ISNA
Tests specifically for the #N/A error.
ISNUMBER
Tests whether a value is numeric.
ISREF
Tests whether a value is a reference.
ISTEXT
Tests whether a value is text.
TYPE
Returns a number code for a value's type.