Kornilios Ampatzis/ April 25, 2019/ Functions

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:

Practice

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.

Share this Post