Use Of 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 :
|
05-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 :
|
05-Jan-98
|
Difference :
|
Error in data entry
|
=IF(ISERROR(D40-D39),"Error in data entry",D40-D39)
|
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें