Excel Core Book
Get our FREE guide on Excel when you subscribe to our free newsletter
Confirms if cell contains any of the Excel errors
Syntax of Excel Iserror formula:
=Check if cell contains an error(to which this value refers)
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
=ISERROR(2+2) will give FALSE
=ISERROR(76/0) will result in TRUE as dividing any number by zero gives #DIV/0 error.