Name
ISERR
Synopsis
Use
ISERR to look at the
specified reference and return a logical value of
TRUE if it refers to any error value with the
exception of #N/A; otherwise, a logical value of
FALSE is returned.
To Calculate
=ISERR(Value)Example
Figure 20-2 illustrates how ISERR can be used to
determine if a cell contains an error value. The function returns a
value of TRUE for all error values with the
exception of #N/A, for which it returns a value of
FALSE.
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
