TYPE Function in Google Sheets

Determine the type of a value in Google Sheets using the TYPE function.

TYPE Function

The TYPE function in Google Sheets returns a number representing the type of a given value.

Syntax

TYPE(value)

Examples

  1. Determine Value Type

Find the type of the value 10:

=TYPE(10)

This will output 1, indicating a number.

  1. Determine Type of Text

Find the type of the value ‘Hello’:

=TYPE("Hello")

This will output 2, indicating text.

Output Values

  • 1: Number
  • 2: Text
  • 3: Logical (TRUE or FALSE)
  • 4: Error
  • 64: Array
  • ISNUMBER: Check if a value is a number.
  • ISTEXT: Check if a value is text.