ISERROR Function (Functions in Excel)
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) |
0 comments:
Post a Comment