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.
Syntax
=ISERROR(CellToTest)
The CellToTest can be a cell reference or a formula.
Formatting
No special formatting is needed.
| Cell to test | Result | |
| 3 | FALSE | =ISERROR(D4) |
| #DIV/0! | TRUE | =ISERROR(D5) |
| #NAME? | TRUE | =ISERROR(D6) |
| #REF! | TRUE | =ISERROR(D7) |
| #VALUE! | TRUE | =ISERROR(D8) |
| #N/A | TRUE | =ISERROR(D9) |
| #N/A | TRUE | =ISERROR(D10) |
Example:
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.
Table 1:
| Start date : | Jan 01 98 | |
| End date : | 5-Jan-98 | |
| Difference : | #VALUE! | =D31-D30 |
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.
Table 2:
| Start date : | Jan 01 98 |
| End date : | 5-Jan-98 |
| Difference : | Error in data entry |
| =IF(ISERROR(D40-D39),”Error in data entry”,D40-D39) |