Information functions, as the name implies, provide information about the contents of cells, such as data types and properties. There are also functions that provide information on a cell’s formatting or location and on the current operating environment.

The Information functions have been grouped into categories to make it easy for you to find the function you need to perform your specific task.

FunctionCategoryDescription
CELLGeneral InformationReturns information about the formatting, location, or contents of a cell (Not available in Excel Online)
ERROR.TYPEError InformationReturns a number corresponding to an error type
INFOGeneral InformationReturns information about the current operating environment (Not available in Excel Online)
ISBLANKOther Data TypeReturns TRUE if the value is blank
ISERRError InformationReturns TRUE if the value is any error value except #N/A
ISERRORError InformationReturns TRUE if the value is any error value
ISEVENNumerical InformationReturns TRUE if the number is even
ISFORMULAOther Data TypeReturns TRUE if there is a reference to a cell that contains a formula (New in Excel 2013)
ISLOGICALOther Data TypeReturns TRUE if the value is a logical value
ISNAError InformationReturns TRUE if the value is the #N/A error value
ISNONTEXTOther Data TypeReturns TRUE if the value is not text
ISNUMBERNumerical InformationReturns TRUE if the value is a number
ISODDNumerical InformationReturns TRUE if the number is odd
ISREFOther Data TypeReturns TRUE if the value is a reference
ISTEXTOther Data TypeReturns TRUE if the value is text
NNumerical InformationReturns a value converted to a number
NAConstant ValueReturns the error value #N/A
SHEETGeneral InformationReturns the sheet number of the referenced sheet (New in Excel 2013)
SHEETSGeneral InformationReturns the number of sheets in a reference (New in Excel 2013)
TYPEOther Data TypeReturns a number indicating the data type of a value