[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

ERROR.TYPE

Syntax:

ERROR.TYPE ( value )

Description: Determines the kind of the error value designated by value.

Arguments:

Name

Type

Description

value

any

A value whose type is to be determined. No conversion shall take place on the argument passed to this function.

 

Return Type and Value: number – The kind of the error value designated by value, as follows:

value

Return Value

#NULL!

1

#DIV/0!

2

#VALUE!

3

#REF!

4

#NAME?

5

#NUM!

6

#N/A

7

Anything else

#N/A

 

[Example:

ERROR.TYPE(A1) results in 2 if A1 evaluates to #DIV/0!
ERROR.TYPE(A1) results in 4 if A1 evaluates to #REF/0!
ERROR.TYPE(A1) results in 7 if A1 evaluates to #N/A
ERROR.TYPE(A1) results in #N/A if A1 evaluates to a non-error value, such as a number or text

end example]