OpenOffice3.org Calc 3. Information Functions

ISNA(value) Function

Returns a logical value. Return TRUE if the argument “value” contains the error value #N/A. The argument “value” contains the reference to the cell you want to evaluate their content. Similary, “value” can contain an expression to be evaluated, depending on the results of expression, the function returns the corresponding logical value. For example:

=ISNA(B19) Returns TRUE if the cell B19 contains the error code #N/A.

 

Back to the list of information functions