.

ISERROR Function Dictionary

Function Dictionary Function Examples Function Categories

ISERROR          
 
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)
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
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)

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download