Returns a number associated with the type of data passed into the function.

Sample Usage





  • value - The data whose type is to be determined.


  • This function returns the following numbers:
    • 1: if value is a number
    • 2: if value is text
    • 4: if value is boolean
    • 16: if value is an error
    • 64: if value is an array
    • 128: for any other type of cell. For example, in-cell images and sparklines.
  • The function cannot determine whether or not a cell or range of cells is using a formula, only returning the type of value being displayed in the cells.

See Also

ISTEXT: Checks whether a value is text.

ISNUMBER: Checks whether a value is a number.

ISLOGICAL: Checks whether a value is `TRUE` or `FALSE`.

ISERROR: Checks whether a value is an error.

Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Clear search
Close search
Google apps
Main menu