It returns TRUE if the formula you specify leads to an error. If there is no error in the formula ISERROR returns FALSE.
The syntax of the function is the following:
ISERROR(value)
value : The value or formula you are checking for an error.
The error types that are evaluated are: N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the ISERROR function:
Use the ISERROR formula to make sure that the cells C10:K10 show the number 0, when the sum of the sales of all the companies is 0 in one month, as for example in August.