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.
