DEFINITION:- Excel Type Function Returns The Type Of Value. We Can Use Type Function In Excel To Test The Value For A Particular Cells In Excel So That Another Functions That Depend On The Type Can Work As Accepted.
The Excel Type Function Returns A Numeric Code That Refer To The Type. The Table Below Shows The Type Of Codes Returned By Type Function And The Meaning For Eacn Return Code.
| Return Code | Description |
|---|---|
| 1 | For Number |
| 2 | For Text |
| 4 | For Logical Type (True Or False) |
| 16 | For Error Value |
| 64 | For Array |
