Skip to content

Information Functions

ERROR.TYPE Returns the corresponding number value associated with an error type in Microsoft Excel.
ISBLANK Returns TRUE if the cell is empty, FALSE if it contains data.
ISERR Returns TRUE if value contains any error value except #N/A, FALSE if it does not.
ISERROR Returns TRUE if value contains any error value (including #N/A), FALSE if it does not.
ISLOGICAL Returns TRUE if value is a logical value, FALSE if it is not.
ISNA Returns TRUE if value is #N/A, FALSE if it is not.
ISNONTEXT Returns TRUE if value is not text, FALSE if it is.
ISNUMBER Returns TRUE if value is a number, FALSE if it is not.
ISREF Returns TRUE if value is a reference, FALSE if it is not.
ISTEXT Returns TRUE if value is text, FALSE if it is not.
N Returns a value converted to a number.
NA An alternative representation of the error value #N/A.
TYPE Determines the type of value in a cell.
Back to top