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.
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:
- In the cell to calculate enter the formula : = TYPE (C6)
- Press Enter -> return value is:
- Similarly copying the formula for the remaining values results:
- Where value is an error value, for example 6 + abc -> the result is an error value -> the function returns value 16.
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
Maybe you are interested
AMD has surpassed Intel in brand value
SQL way to count NULL and NOT NULL values in a column
Comparing Odroid-N2+ and Raspberry Pi 4: Which option offers better value?
How to receive free gifts from IObit with a total value of nearly 150,000 USD
Write a program to find duplicate values in Python
Write a program to check duplicate values in Python