ERROR.TYPE
Returns a number corresponding to an error type.
Error Handling & Checks functions help you keep spreadsheets stable. Use them to catch errors, display friendly outputs, and prevent cascading issues.
This collection groups Excel functions that are commonly used for error handling & checks workflows. Instead of browsing hundreds of formulas, you can focus on the exact tools that solve this type of task.
Each function page includes a short explanation and practical usage context. Use these functions as standalone tools or combine them to build more advanced, maintainable formulas.
If you frequently work with reports, dashboards, or recurring templates, bookmarking the key functions from this collection will speed up your day-to-day work.
Returns a number corresponding to an error type.
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.
Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression.
Returns TRUE if the value is blank.
Returns TRUE if the value is any error value except #N/A.
Returns TRUE if the value is any error value.
Returns TRUE if the value is the #N/A error value.
Returns TRUE if the value is a number.
Returns TRUE if the value is text.
Returns the error value #N/A.