Class Errortype
java.lang.Object
org.apache.poi.ss.formula.functions.Fixed1ArgFunction
org.apache.poi.ss.formula.functions.Errortype
- All Implemented Interfaces:
Function,Function1Arg
Implementation for the ERROR.TYPE() Excel function.
Note - the results of ERROR.TYPE() are different to the constants defined in
ErrorConstants.
Syntax:
ERROR.TYPE(errorValue)
Returns a number corresponding to the error type of the supplied argument.
| errorValue | Return Value |
| #NULL! | 1 |
| #DIV/0! | 2 |
| #VALUE! | 3 |
| #REF! | 4 |
| #NAME? | 5 |
| #NUM! | 6 |
| #N/A! | 7 |
| everything else | #N/A! |
- Author:
- Josh Micich
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionMethods inherited from class org.apache.poi.ss.formula.functions.Fixed1ArgFunction
evaluate
-
Constructor Details
-
Errortype
public Errortype()
-
-
Method Details
-
evaluate
Description copied from interface:Function1Arg
-