|
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.
|
|
|
Welcome to Easy Web Tips! We’re here to simplify navigating the digital world with beginner-friendly tutorials on essential tools and online platforms. From setting up Google accounts to mastering Gmail, organizing files in Google Drive, and even learning quick video editing tips, our step-by-step guides help you become more productive and secure online.