Information functions

Information functions return details about cells, ranges and values — their data type and formatting, and whether they contain errors, blanks, text or numbers — which is useful for inspecting data and guarding formulas against unexpected input.