ISERROR

Posted on 18-01-2020 , by: admin , in , 0 Comments

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)

Leave a comment