Buzz
Besides Excel's ISERR function, which returns True if the value is any error except #N/A, readers can explore other articles on Mytour to delve into functions like IFERROR and FORECAST.ETS.CONFINT in Excel.
Excel's ISERROR function
Understanding ISERROR and ISERR Functions in Excel
Both Excel functions Iserror and Iserr check values and return True or False, depending on whether the value is an error.
However, there are differences between these functions:
- Iserror returns True if the provided value is any error.
- Iserr returns True if the provided value is an error, excluding #N/A.
Describing the ISERR Function in Excel, returning True if the value is any error except #N/A
The Excel Iserr function checks if an expression (or value) provided initially returns any Excel error, excluding #N/A. If true, the function returns the logical value TRUE; otherwise, it returns FALSE.
The syntax of the ISERR function in Excel is:
ISERR( value )
Where the value parameter is the expression or value to be checked.
Example of the ISERR function in Excel, returning True if the value is any error except #N/A
Column B of the following spreadsheet illustrates examples of the Excel Iserr function.
Formula:
Returned Result:
In the example above, the arguments provided to the Iserr function include:
- Values in cells B1 - B3.
- Values returned from 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 find more detailed information on Excel formula error messages, readers can visit the Excel formula error message page.
Here Mytour has just introduced you to the ISERR function in Excel, returning True if the value is any error except #N/A. Additionally, to explore more common Excel functions like the VALUE function, readers should stay tuned for Mytour's upcoming articles.
