Menu
EXCEL TYPE FUNCTION
Excel TYPE Function Introduction
The kind of value in a cell is represented by a numeric code returned by this function. When the action of another function is dependent on the type of value in a certain cell, use TYPE.
Description of Excel TYPE Function
Syntax:
=TYPE (value)
Parameter list:
- value – the value for which the type should be checked.
Step By Step Guide of TYPE Function
- If the value is a number, TYPE returns 1,
- if it is a text, it returns 2,
- if it is a logical value, it returns 4,
- and if it is an error value, it returns 16.
- Array TYPE returns 64 if the value is Array.
Key Points
- When utilizing methods like ARGUMENT and INPUT that take many types of data, TYPE comes in handy. To determine what type of data a function or formula returns, use TYPE.
- You can’t use TYPE to check if a cell has a formula in it. Only the type of the resultant, or displayed, value is determined by TYPE.
- TYPE returns the type of the formula’s resultant value if value is a cell reference to a cell that contains a formula.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
