Returns a number corresponding to the specified error value.
Syntax
 Copy Code
|
|---|
ERROR.TYPE( Error e ) → Number |
Parameters
- e
- Required. The error value.
Remarks
The following table contains the values that correspond to some of the predefined errors:
Error | Value |
|---|---|
#NULL! | 1 |
#DIV/0! | 2 |
#VALUE! | 3 |
#REF! | 4 |
#NAME? | 5 |
#NUM! | 6 |
#N/A | 7 |
#ERROR! | 8 |
The parameter can be an actual error value or a reference to a cell containing a formula. If e is not an error value, the function returns the #N/A error value. The ERROR.TYPE function is useful in an IF function to test for an error value and return a text string, such as a message, instead of the actual error value.
Note that this function does not propagate error values.
Example
| Formula
Copy Code
|
|---|
=ERROR.TYPE(1/0) |
See Also
Function Reference
NA Function