Name
ISERROR
Synopsis
Use
ISERROR to look at the
specified reference and return a logical value of
TRUE if the cell contains an error value;
otherwise, a logical value of FALSE is returned.
To Calculate
=ISERROR(Value)Example
Figure 20-2 illustrates how ISERROR can be used to
determine if a cell contains any type of error value. The function
returns a value of FALSE for all error values in
Excel, as shown in the example.
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.
