Confirms if cell contains any of the Excel errors

Syntax of Excel Iserror formula:

In words:
=Check if cell contains anĀ error(to which this value refers)

Explanation of Excel Isrror formula

Excel ISERROR function checks for 7 different types of errors found in Excel i.e. #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, #NULL!

If value is referring to any cell that contains either of these errors then formula will return TRUE. If not then it will return FALSE

Examples of Excel Iserror formula

=ISERROR(2+2) will give FALSE
=ISERROR(76/0) will result in TRUE as dividing any number by zero gives #DIV/0 error.