Scribd
Upload
4 views1 page

Excel TYPE Function Explained

The =TYPE() function in Excel is used to determine the datatype of a value in a cell. It returns a numeric code representing the datatype, such as 1 for numbers, 2 for text, and 4 for Boolean/logical. Additionally, Excel treats dates and times as numbers, returning 1 for those values as well.

Uploaded by

aditi05614901722
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views1 page

Excel TYPE Function Explained

The =TYPE() function in Excel is used to determine the datatype of a value in a cell. It returns a numeric code representing the datatype, such as 1 for numbers, 2 for text, and 4 for Boolean/logical. Additionally, Excel treats dates and times as numbers, returning 1 for those values as well.

Uploaded by

aditi05614901722
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

TYPE function in Excel

In excel, =TYPE() function is used to check the datatype of a data stored in a cell.

Syntax: =TYPE(value), where value is the data whose data type we need to check

The type function returns a numeric value, representing the datatype of the data as
follows:-

TypeCode Meaning
1 Number
2 Text
4 Boolean/logical
16 Error
64 Array

For example, =TYPE(50), returns 1 and =TYPE(“NINJA”), returns 2

Also note that Excel date and time are numbers, so they will return 1.

You might also like