Google Sheets info functions
Info functions in Google Sheets, explained with live examples.
18 info functions in Google Sheets — 1 documented in depth so far, the rest indexed below and landing every week.
Documented info functions
Syntax, examples, and the equivalent — ready now.
All Google Sheets info functions
The full set — deep dives on the way.
- ERROR.TYPE
- Returns a number corresponding to the error value in a different cell.
- ISBLANK
- Checks whether the referenced cell is empty.
- ISDATE
- Returns whether a value is a date.
- ISEMAIL
- Checks whether a value is a valid email address.
- ISERR
- Checks whether a value is an error other than `#N/A`.
- ISERROR
- Checks whether a value is an error.
- ISFORMULA
- Checks whether a formula is in the referenced cell.
- ISLOGICAL
- Checks whether a value is `TRUE` or `FALSE`.
- ISNA
- Checks whether a value is the error `#N/A`.
- ISNONTEXT
- Checks whether a value is non-textual.
- ISNUMBER
- Checks whether a value is a number.
- ISREF
- Checks whether a value is a valid cell reference.
- ISTEXT
- Checks whether a value is text.
- N
- Returns the argument provided as a number.
- NA
- Returns the "value not available" error, `#N/A`.
- SHEETS
- Returns the total number of sheets in the referenced spreadsheet. .
- TYPE
- Returns a number associated with the type of data passed into the function.
More Google Sheets function categories