[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
ISERR ( value )
Description: Determines if value is any of the error values other than #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 one of the error values, excluding #N/A; otherwise, FALSE.
[Example:
ISERR(A1) results in TRUE if A1 evaluates to #DIV/0!, for example
ISERR(B1) results in FALSE if B1 evaluates to #N/A
end example]