Class Errortype

java.lang.Object
org.apache.poi.ss.formula.functions.Fixed1ArgFunction
org.apache.poi.ss.formula.functions.Errortype
All Implemented Interfaces:
Function, Function1Arg

public final class Errortype extends Fixed1ArgFunction
Implementation for the ERROR.TYPE() Excel function.

Syntax:
ERROR.TYPE(errorValue)

Returns a number corresponding to the error type of the supplied argument.

errorValueReturn Value
#NULL!1
#DIV/0!2
#VALUE!3
#REF!4
#NAME?5
#NUM!6
#N/A!7
everything else#N/A!
Note - the results of ERROR.TYPE() are different to the constants defined in ErrorConstants.

Author:
Josh Micich