|
ERROR.TYPE |
  
|
|
ERROR.TYPE |
|
This function returns a number corresponding to one of the error values.
Syntax
ERROR.TYPE(errorvalue)
Arguments
The valid error values that can be used in the arguments and their corresponding returned values are summarized here:
Error Value |
Function Returns |
#NULL! |
1 |
#DIV/0! |
2 |
#VALUE! |
3 |
#REF! |
4 |
#NAME? |
5 |
#NUM! |
6 |
#N/A |
7 |
Remarks
You can use this function in an IF-THEN structure to test for the error value and return a text string, such as a message, instead of the error value.
Data Types
Accepts error value as data. Returns numeric data.
Examples
ERROR.TYPE(B13)
ERROR.TYPE(R13C2)
ERROR.TYPE(#REF!) gives the result 4
See Also