Excel Information Functions

This section will learn  how to use Excel’s  Information Functions such as: Cell, Error.type, Info, ISBlank, ISError, etc.

CELL – returns information about the formatting, location, size, or contents of a cell.

ERROR.TYPE – returns a numeric value of one of the error type in EXCEL. If No error exists, the #N/A error will be returned.

INFO – returns information about the operating environment.

ISBLANK – returns TRUE if the value is blank or null.

ISERROR – returns TRUE if the value is any error value except #N/A.

ISNUMBER – returns TRUE if the value in a cell is a numeric value, otherwise it will return FALSE.

ISERR – returns TRUE if the value is any error value except #N/A.

ISNA – used to check if a cell contains the #N/A error, if so, returns TRUE; otherwise, the ISNA function returns FALSE.

ISTEXT – used to check if a value is text. If so, returns TRUE; if the text is not text, the function will return FALSE.

ISNONTEXT – used to check if a value is text. If so, returns FALSE; if the text is not text, the function will return TRUE.

ISREF – used to check if a value is a valid reference.

N – converts a value to a numeric value.

Type – returns the type of a value.

NA – returns the #N/A error value.

Leave a Reply