Buzz
In this article, we'll introduce you to some insights and examples of ISERROR function in Excel, which assesses the provided expression for errors. Besides ISERROR function, readers can explore additional articles on the ROUND function in Excel, rounding numbers on Mytour.
The ISERROR function in Excel
Understanding ISERROR and ISERR functions in Excel
Both Excel functions Iserror and Iserr assess values and return True or False depending on whether the value is an error or not.
However, there are distinctions between these functions:
- Iserror function returns True if the provided value is any error.
- Iserr function returns True if the provided value is any error, except for the #N/A error.
Description of ISERROR function in Excel, checking the provided expression
Excel's Iserror function checks if an expression (or value) initially provided returns an Excel error, the function will return the logical value TRUE, otherwise FALSE.
The syntax of ISERROR function in Excel is as follows:
ISERROR( value )
Where the value parameter is the expression or value to be checked.
Example of ISERROR function in Excel, checking the provided expression
Below is an illustrative example of Excel's Iserror function.
Formula:
Returned result:
In the example above, the parameters for the Excel Iserror function are:
- Simple values in cells B1-B3.
- Expressions in cells B4 and B5 (note that dividing by 0 in cell B4 will return the # DIV/0! error).
- Cell references in cells B6 and B7.
To explore further details on various Excel error messages, you can visit the Excel formula error page.
Above are the details and examples related to the ISERROR function in Excel, which checks the provided expression. Additionally, readers can explore other articles on Mytour to understand functions like ERROR.TYPE, FIXED, Round, and NUMBERVALUE in Excel.
