[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
ISNA ( value )
Description: Determines if value is the error value #N/A.
Arguments:
|
Name |
Type |
Description |
|
any |
The value to be tested. No conversion shall take place on an argument passed to this function. |
Return Type and Value: logical – TRUE if value is #N/A; otherwise, FALSE.
[Example:
ISERR(A1) results in TRUE if A1 evaluates to #N/A
ISERR(B1) results in TRUE if B1 evaluates to #DIV/0!, for example
end example]