ERROR.TYPE function
Returns a number corresponding to an error type
Syntax
ERROR.TYPE(error_val)Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| error_val | Yes | The error value whose identifying number you want to find."#NULL!" |
Try ERROR.TYPE
Give diagnostic codes only to genuine errors
=VSTACK(IFERROR(ERROR.TYPE(A2:A4),0),ERROR.TYPE(1/0),ERROR.TYPE(NA()),ERROR.TYPE(VALUE("invalid")))The three literal strings are not error values, so ERROR.TYPE returns #N/A for each; IFERROR makes those diagnostic rows numeric zero. The later expressions create genuine division, missing-value and value errors, yielding codes 2, 7 and 3. The function tests a value type rather than its displayed spelling.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
ERROR.TYPE · inside IFERROR
=VSTACK(IFERROR(ERROR.TYPE(A2:A4),0),ERROR.TYPE(1/0),ERROR.TYPE(NA()),ERROR.TYPE(VALUE("invalid")))Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.