Excel Information Functions

Excel Information Functions - Links to Each of the Built-In Information Functions with Full Description, Examples and Common Errors.

FunctionPurposeParam,Optional
CELL Get information about a cell info_typereference
ERROR.TYPE Test for a specific error value error_val
INFO Get information about current environment type_text
ISBLANK Test if a cell is empty value
ISERR Test for any error but #N/A value
ISERROR Test for any error value
ISEVEN Test if a value is even value
ISFORMULA Test if cell contains a formula reference
ISLOGICAL Test if a value is logical value
ISNA Test for the #N/A error value
ISNUMBER Test for numeric value value
ISODD Test if a value is odd value
ISREF Test for a reference value
ISTEXT Test for a text value value
N Convert a value to a number value
NA Create an #N/A error
TYPE Get the type of value in a cell value