Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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:

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 »
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 »