TYPE function - Function that returns the data type of any value in Excel
The following article introduces you to the TYPE function - one of the functions in the information function group is very popular in Excel.
TYPE function - Function that returns the data type of any value in Excel Picture 1
Description: The function returns the data type of any value. Application of functions in functions depends on the type of value.
Syntax: TYPE (value)
Inside:
- value: Any value to determine the data type, is a required parameter, the return value of the function corresponds to the data type as follows:
+ value in numeric form -> function returns value 1.
+ value in text form -> function returns value 2.
+ value is a logical value -> the function returns 4.
+ value are error values -> the function returns 16 value.
+ value in array form -> function returns 64 value.
Attention:
- TYPE function is most useful when combined with functions that use many different data types such as ARGUMENT, INPUT.
- Cannot use TYPE function in determining whether cell contains formula or not.
For example:
Determine the data type of the values described in the following table:
TYPE function - Function that returns the data type of any value in Excel Picture 2
- In the cell to calculate enter the formula : = TYPE (C6)
TYPE function - Function that returns the data type of any value in Excel Picture 3
- Press Enter -> return value is:
TYPE function - Function that returns the data type of any value in Excel Picture 4
- Similarly copying the formula for the remaining values results:
TYPE function - Function that returns the data type of any value in Excel Picture 5
- Where value is an error value, for example 6 + abc -> the result is an error value -> the function returns value 16.
TYPE function - Function that returns the data type of any value in Excel Picture 6
Above are instructions and some specific examples when using TYPE function in Excel.
Good luck!
You should read it
- Type () function in Python
- ERROR.TYPE function - The function returns the number corresponding to one of the error values in Microsoft Excel
- T.TEST function - The function returns the probability associated with Student's t-Test in Excel
- TRIMMEAN function - The function returns the average of the inner part of a dataset in Excel
- QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excel
- How to use the IF function in Excel
- PERCENTILE function - The function returns the kth percentile in Excel
- DATEPART function in SQL Server
- FTEST function - The function returns the result of an F-Test in Excel
- How to use the IFS function in Excel 2016
- HARMEAN function - The function returns the harmonic average of a data set in Excel
- GEOMEAN function - The function returns the average of a positive array or range of data in Excel
May be interested
NA function - The function returns the # N / A error value in Excel
Guide to familiarize yourself with Excel
How to create the first Workbook in Excel
How to use functions to identify and calculate date information in Excel
STDEVA function - The function of estimating standard deviations based on a sample including both text and logical values in Excel
STDEVPA function - The function of estimating standard deviations based on an entire population including both text and logical values in Excel