Microsoft Office Tutorials and References
In Depth Information
Examples of Information Functions
ISERR
ISERR This function is similar to ISERROR, except it does not report
#N/A errors.
ISNA
ISNA This function specifically tests whether a result returns an
#N/A error.
ERROR.TYPE
ERROR.TYPE This function lets you know specifically what error
is being returned. This function returns a value from 1 through 7 to
indicate #NULL!, #DIV/0!, #VALUE!, #REF!, #NAME?, #NUM!, and #N/A,
respectively. It is possible to write a lengthy formula such as the
following to decode these values and provide a friendlier error mes-
sage:
Click here to view code image
=IF(NOT(ISERROR(A2)),A2,CHOOSE(ERROR.TYPE(A2),"Null Value
Found",
"Division by Zero","Invalid Value","Missing Reference","Undefined
Name",
"Numeric Error","Value Not Available"))
Figure 12.10.
Figure 12.10. The results of
The results of IIS functions for detecting errors.
functions for detecting errors.
Search JabSto ::




Custom Search