InformationLevel: ExpertAvailable in: Excel 2007+
In this article
- Syntax
- Examples
- Example 1
- Related functions
ERROR.TYPE returns a number for each error (1 #NULL!, 2 #DIV/0!, 3 #VALUE!, 4 #REF!, 5 #NAME?, 6 #NUM!, 7 #N/A) so you can react differently to each.
Syntax
=ERROR.TYPE(error_val)
| Argument |
What it means |
error_val |
A formula that may error. |
Examples
Example 1
=IFERROR(C2, CHOOSE(ERROR.TYPE(C2), "", "No sales", "Bad data", "Broken link", "Typo", "Too big", "Not found"))
Friendly messages per error type.
IFERROR · ISERR
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
✨ Ask AI about this articleStuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong