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.