Google Sheets | TYPE Function | Get Type of Data | Spreadsheet Tutorial with Example

Use the Google Sheets TYPE function to get the data type of the specified
argument. The TYPE function has only argument, value. It can be, for
example, a hard-coded value or a reference to a cell.

TYPE returns a number, which is specific to a data type. For example, if
TYPE returns 2, the value is text.

-------------------------------------
Google Sheets Quiz with Demo of Answers

Try this 5-question quiz, which also demos the answers. The quiz
can be helpful in your day-to-day spreadsheet work or for job interview:

https://youtu.be/rlcc03qQfcI
-------------------------------------

The TYPE function can be more useful, when combined with a function like IF.

Here's the format of the TYPE function formula:

=TYPE(value)

Start the formula with an equal-to symbol.

TYPE is the name of the function.

value, for example, can be hard-coded data, typed between double quotes, or it can be a reference to a cell.

Let's look at an example:

=TYPE("accounting")

The above TYPE function formula returns 2, which means the specified argument is text.

Here are the numbers that TYPE will return for other data types:

1 Indicates value is a number.
4 Indicates value is boolean.
16 Indicates value is an error.
64 Indicates value is an array.
128 For other data types. For example, an image.

Take a look at this video tutorial, which gives the steps to use the Google Sheets TYPE function, with examples.