Navigation:  Formula Reference > Spreadsheet Formula Functions >

TYPE

Previous pageReturn to chapter overviewNext page

 

This function returns the type of value.

Syntax

TYPE(value)

Arguments

The argument is any value as summarized here:

Type of Value

Returned Number

Number

1

DateTime object

1

TimeSpan object

1

Text

2

Logical value

4

Error value

16

Array

64

Data Types

Accepts many types of data. Returns numeric data.

Examples

TYPE(G15)

TYPE(R15C7)

TYPE(154) gives the result 1

TYPE("String") gives the result 2

TYPE(TRUE) gives the result 4

 

See Also

ERROR.TYPE

ISERROR

ISLOGICAL

ISNUMBER

ISTEXT