The Excel ISERROR function returns TRUE for any error type that excel generates, including #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! You can use the ISERR function together with the IF function to test for an errors and display a custom message, or run a different calculation when found.
Test for any error
A logical value (TRUE or FALSE)
value - The value to check for any error.
Use the ISERROR function to see if a cell contains any error message, including #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!
For example, =ISERROR(A1) will return TRUE if A1 is is displaying an one of the errors mentioned above , and FALSE if not.
Frequently, value is supplied as a cell address, but you can use it to trap errors inside more complex formulas as well.
If you need to extract the first word from some text you can use a formula that uses the FIND and LEFT functions. From the example, the formula looks like this:
How this formula...
To count the number of cells that contain errors, you can use the ISERR and NOT functions, wrapped in the SUMPRODUCT function. In the generic form of the formula (above) rng represents the range in which you'd like to...
If you need to match the first error in a range of cells, you can use an array formula based on the MATCH and ISERROR functions.
In the example shown, the formula is:
This is an...
To count the number of cells that contain errors, you can use the ISERR function, wrapped in the SUMPRODUCT function. In the generic form of the formula (above) rng represents the range of cells in which you'd like to...
To find the position (row) of the last file revision in a table, you can use a formula based on several Excel functions: MAX, IF, ISERROR, ROW, and INDEX.
In the example shown, the formula in cell H6 is:
Learn Excel formulas and functions with concise, clear videos. Master absolute/relative addresses, dates, text, named ranges, and tools for troubleshooting. Each video comes with a practice worksheet and audio transcript. Instant access and complete 100% guarantee. Start today!