Google Sheets info functions
Info functions in Google Sheets, explained with live examples.
18 info functions in Google Sheets — 18 documented in depth so far, the rest indexed below and landing every week.
Documented info functions
Syntax, examples, and the equivalent — ready now.
- CELLReturns the requested information about the specified cell.InfoExcel
- ERROR.TYPEReturns a number corresponding to the error value in a different cell.InfoExcel
- ISBLANKChecks whether the referenced cell is empty.InfoExcel
- ISDATEReturns whether a value is a date.InfoNo Excel equivalent
- ISEMAILChecks whether a value is a valid email address.InfoNo Excel equivalent
- ISERRChecks whether a value is an error other than `#N/A`.InfoExcel
- ISERRORChecks whether a value is an error.InfoExcel
- ISFORMULAChecks whether a formula is in the referenced cell.InfoExcel
- ISLOGICALChecks whether a value is `TRUE` or `FALSE`.InfoExcel
- ISNAChecks whether a value is the error `#N/A`.InfoExcel
- ISNONTEXTChecks whether a value is non-textual.InfoExcel
- ISNUMBERChecks whether a value is a number.InfoExcel
- ISREFChecks whether a value is a valid cell reference.InfoExcel
- ISTEXTChecks whether a value is text.InfoExcel
- NReturns the argument provided as a number.InfoExcel
- NAReturns the "value not available" error, `#N/A`.InfoExcel
- SHEETSReturns the total number of sheets in the referenced spreadsheet.InfoExcel
- TYPEReturns a number associated with the type of data passed into the function.InfoExcel
More Google Sheets function categories