TYPE

Find an error code corresponding to the error value in Excel
Returns a number corresponding to an error type

Rational

Find the data type of value

Description

The Excel TYPE function returns data type of reference cell or value of an argument. Example, =TYPE(“ABC”) return data type 2 (Text data format).

See below for the list of value arguments and the respective results.

Syntax

=TYPE(value)

Parameters

value – Reference to check the data type

Return Value

A numerical value of data type (see below)

Key Notes

  • The TYPE function only evaluates the result of formula and function
  • In the Excel Date and Currency format, data is stored in number.

The function return data type based on the reference argument, the following are five data categories of Microsoft Excel: 

If value isData Type
Number1
Text2
Logical value4
Error value16
Array64

Keep Reading Similar Functions:

Check a cell for non-text value in Excel

ISNONTEXT

The ISNONTEXT function checks if a specified cell has non-text value and returns “TRUE” when a cell has a non-text, and “FALSE” it contains a text value.

Read More »
Check a cell for the text value in Excel

ISTEXT

The Excel ISTEXT function check if a specified cell has a value in text format and returns “TRUE” when a cell contains a text value, and “FALSE” if not.

Read More »
Find an error code corresponding to the error value in Excel

ERROR.TYPE

The Excel ERROR.TYPE function returns an integer code of the corresponding error type or returns the #N/A if no error exists.

Read More »