ISERROR
What Does It Do ?
This function tests a cell or calculation to determine whether an error has been generated.
It will show TRUE for any type of error and FALSE if no error is found.
This function tests a cell or calculation to determine whether an error has been generated.
It will show TRUE for any type of error and FALSE if no error is found.
Syntax
=ISERROR(CellToTest)
The CellToTest can be a cell reference or a formula.
=ISERROR(CellToTest)
The CellToTest can be a cell reference or a formula.
Formatting
No special formatting is needed.
No special formatting is needed.
Example
The following tables was used to calculate the difference between two dates.
The following tables was used to calculate the difference between two dates.
Table 1 shows an error due to the fact that the first entry was entered using an inappropriate
date format.
date format.
Table 2 shows how the =ISERROR() function has been used to trap the error and inform the
user that there has been an error in the data entry.
user that there has been an error in the data entry.
=IF(ISERROR(D40 -D39),”Error in data entry”,D40-D39)