TYPE

Definition: The TYPE function in Excel is used to determine the data type of a value.

Syntax: ==TYPE(value).

Situation: This formula is appropriate in situations where you need to determine the data type of a value.

Example: If you have a cell that contains the value “10”, you would use the formula =TYPE(A1). This would return a value of 1, which indicates that the value is a number.