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

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
A2 = "-0.3"

A1 <> A2 -0.3 <> -0.3 (FALSE)

See Also

xlpISEQUAL
xlpISGREATER
xlpISGREATEROREQUAL
xlpISLESS
xlpISLESSOREQUAL