Excel info functions
Info functions in Excel, explained with live examples.
22 info functions in Excel — 22 documented in depth so far, the rest indexed below and landing every week.
Documented info functions
Syntax, examples, and the equivalent — ready now.
- CELLReturns information about the formatting, location, or contents of a cellThis function is not available in Excel for the web.InfoGoogle Sheets
- ERROR.TYPEReturns a number corresponding to an error typeInfoGoogle Sheets
- INFOReturns information about the current operating environmentThis function is not available in Excel for the web.InfoNo Google Sheets equivalent
- ISBLANKReturns TRUE if the value is blankInfoGoogle Sheets
- ISERRReturns TRUE if the value is any error value except #N/AInfoGoogle Sheets
- ISERRORReturns TRUE if the value is any error valueInfoGoogle Sheets
- ISEVENReturns TRUE if the number is evenInfoGoogle Sheets
- ISFORMULAReturns TRUE if there is a reference to a cell that contains a formulaInfoGoogle Sheets
- ISLOGICALReturns TRUE if the value is a logical valueInfoGoogle Sheets
- ISNAReturns TRUE if the value is the #N/A error valueInfoGoogle Sheets
- ISNONTEXTReturns TRUE if the value is not textInfoGoogle Sheets
- ISNUMBERReturns TRUE if the value is a numberInfoGoogle Sheets
- ISODDReturns TRUE if the number is oddInfoGoogle Sheets
- ISOMITTEDChecks whether the value in a LAMBDA is missing and returns TRUE or FALSEInfoNo Google Sheets equivalent
- ISREFReturns TRUE if the value is a referenceInfoGoogle Sheets
- ISTEXTReturns TRUE if the value is textInfoGoogle Sheets
- NReturns a value converted to a numberInfoGoogle Sheets
- NAReturns the error value #N/AInfoGoogle Sheets
- SHEETReturns the sheet number of the referenced sheetInfoGoogle Sheets
- SHEETSReturns the number of sheets in a referenceInfoGoogle Sheets
- STOCKHISTORYRetrieves historical data about a financial instrument and loads it as an arrayInfoNo Google Sheets equivalent
- TYPEReturns a number indicating the data type of a valueInfoGoogle Sheets
More Excel function categories