ERROR.TYPE Function (Functions in Excel)
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. |
0 comments:
Post a Comment