Error.Type Formula
|
|
Data
|
|
The Error
|
Error Type
|
|
|
|
|
10
|
0
|
#DIV/0!
|
2
|
=ERROR.TYPE(E4)
|
|
|
|
10
|
3
|
#NAME?
|
5
|
=ERROR.TYPE(E5)
|
|
|
|
10
|
3
|
#REF!
|
4
|
=ERROR.TYPE(E6)
|
|
|
|
10:00
|
13:00
|
################
|
#N/A
|
=ERROR.TYPE(E7)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
What Does It Do?
|
|
|
|
|
||
|
This
function will show a number which corresponds to an error produced by a
formula.
|
||||||
|
|
|
|
|
|
|
|
|
Syntax
|
|
|
|
|
|
|
|
=ERROR.TYPE(Error)
|
|
|
|
|||
|
Error is the cell reference where the
error occurred.
|
|
|
||||
|
|
|
|
|
|
|
|
|
Formatting
|
|
|
|
|
||
|
The
result will be formatted as a normal number.
|
|
|
||||
|
|
|
|
|
|
|
|
|
Example
|
|
|
|
|
|
|
|
See
Example 4 in the =DGET() function.
|
|
|
||||