PrecisionCalc
xl
Precision
Get Your Numbers Right
xlpISNOTEQUAL
Determines whether two numbers are not equal, with up to 32,767 significant digits of precision. Returns TRUE if the numbers are not equal; returns FALSE if they are equal. Returns #NUM! if either input cannot be resolved to a valid number.
Syntax
xlpISNOTEQUAL(number1,number2)
number1 | Required. The first number to be compared. |
number2 | Required. The second number to be compared. |
Remarks
number1 and number2 can accept both numbers and text.
number1 and number2 can accept text formatted with the local currency symbol and thousands separators, and negatives can be formatted with either a leading hyphen or parentheses.
number1 and number2 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 |
=xlpISNOTEQUAL(2,2) | 2 <> 2 | FALSE |
=xlpISNOTEQUAL(2.1,-3.1) | 2.1 <> -3.1 | TRUE |
=xlpISNOTEQUAL("2abc2",3) | 2abc2 <> 3 | #NUM! |
=xlpISNOTEQUAL(A1,A2)
A1 = -0.3 |
A1 <> A2 | -0.3 <> -0.3 (FALSE) |
See Also
xlpISEQUAL
xlpISGREATER
xlpISGREATEROREQUAL
xlpISLESS
xlpISLESSOREQUAL