PrecisionCalc
xl
Precision
Get Your Numbers Right

 

xlpISGREATEROREQUAL

Determines whether one number is larger than or equal to another, with up to 32,767 significant digits of precision. Returns TRUE if the first number is larger than or equal to the second; returns FALSE if the first number is smaller than the second number. Returns #NUM! if either input cannot be resolved to a valid number.

Syntax

xlpISGREATEROREQUAL(number1,number2)

number1 Required. The first number to be compared.
number2 Required. The second number to be compared.

Remarks

Examples

Formula Description Result
=xlpISGREATEROREQUAL(2,2) 2 >= 2 TRUE
=xlpISGREATEROREQUAL(2.1,-3.1) 2.1 >= -3.1 TRUE
=xlpISGREATEROREQUAL("2abc2",3) 2abc2 >= 3 #NUM!
=xlpISGREATEROREQUAL(A1,A2)

A1 = -0.3
A2 = "-0.3"

A1 >= A2 -0.3 >= -0.3 (TRUE)

See Also

xlpISEQUAL
xlpISNOTEQUAL
xlpISGREATER
xlpISLESS
xlpISLESSOREQUAL