Use Of ERROR.TYPE
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.
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें