PrecisionCalc
xl
Precision
Get Your Numbers Right
xlpISERROR
Determines whether a value returned by an xlPrecision function is an error value. Returns TRUE if it is an error; FALSE if not.
Syntax
xlpISERROR(num)
| num | Required. The value to determine whether it is an error. |
Remarks
num can accept both numbers and text.
num can accept text formatted with the local currency symbol and thousands separators, and negatives can be formatted with either a leading hyphen or parentheses.
num can accept text up to 32,767 characters long.
If any xlPrecision edition other than the 32,767 SD edition is being used, number1 and number2 are rounded down to the maximum number of significant digits allowed by the edition in use.
Examples
| Formula | Description | Result |
| =xlpISERROR(xlpADD(1,0)) | Determines whether the value returned by xlpADD(1,0) is an error | FALSE |
| =xlpISERROR(xlpDIVIDE(1,0)) | Determines whether the value returned by xlpDIVIDe(1,0) is an error | TRUE |