Name
ISNA
Synopsis
Use
ISNA to look at the specified reference
and return a logical value of TRUE
if it contains
the #N/A
(value not available) error value;
otherwise, the function returns a value of FALSE
.
To Calculate
=ISNA(Value
)
Example
Figure 20-2 illustrates how ISNA can be used to
determine if a cell contains a value of #N/A
. The
function returns a value of TRUE
for the cell that
contains an error value of #N/A
and
FALSE
for all other values.
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.