TYPE

Description

TYPE returns the argument type of the given expression.

Syntax

TYPE ( expression )

 

Parameter

Description

expression

Any expression.

Remarks

The valid values returned by this argument are:

 

Number

Description

1

Number

2

Text string

4

Logical value

16

Error value

Examples

This function returns 1 if cell A1 contains a number:

TYPE(A1)

This function returns 2:

TYPE("Customer")

Also, see

ISBLANK

ISERR

ISERROR

ISLOGICAL

ISNA

ISNONTEXT

ISNUMBER

ISREF

ISTEXT