Returns an integer representing the data type of a value.
Sintassi
TYPE(value)Argomenti
valueobbligatorio
The value you want to test for its data type.
The TYPE function identifies the data type of a given value. It returns 1 for numbers, 2 for text, 4 for logical values, 16 for error values, and 64 for arrays.
=TYPE(100)→1Returns 1 because 100 is a number.
=TYPE("Hello")→2Returns 2 because "Hello" is a text string.
Select a cell
Click on the cell where you want to display the data type result.
Enter the formula
Type =TYPE(value) and replace 'value' with the cell reference or data you want to check.
A result of 16 indicates that the value provided is an error value, such as #N/A or #VALUE!.