Comparison Functions

Home > System Defined Functions Reference > Comparison Functions

Function	Description	Syntax
EQ GE GT LE LT NE	These functions perform a rounded comparison. For example, EQ(Num1,Num2, NumDigits) is equivalent to Round(Num1,NumDigits) = Round(Num2,NumDigits), and so on. EQ is = GT is > LT is < GE is >= LE is <= NE is !=	EQ(Num1, Num2, [NumDigits=0])

Function

Description

Syntax

These functions perform a rounded comparison. For example, EQ(Num1,Num2, NumDigits) is equivalent to Round(Num1,NumDigits) = Round(Num2,NumDigits), and so on.

EQ is =
GT is >
LT is <
GE is >=
LE is <=
NE is !=

EQ(Num1, Num2, [NumDigits=0])