ISERROR Formula in Excel

 

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.

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

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