Microsoft Office Tutorials and References
In Depth Information
Examples of Information Functions
ISERR — This function is similar to ISERROR, except it does not report
ISNA — This function specifically tests whether a result returns an
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-
Click here to view code image
"Division by Zero","Invalid Value","Missing Reference","Undefined
"Numeric Error","Value Not Available"))
Figure 12.10. The results of
The results of IIS functions for detecting errors.
functions for detecting errors.