Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

TYPE

Description: Returns the type of value, for example, number = 1, text = 2, logical value = 4, error value = 16, and array = 64. Use TYPE when the behavior of another function depends on the type of value in a particular cell.

Syntax: TYPE(Value)

If Value is TYPE returns
Number 1
Text 2
Logical value 4
Error value 16
Array 64

Remarks:

Example:

If A1 contains the text "Smith", then:

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.