EXAMPLE - Comparison Functions1

LESSTHAN Function

Returns true if the first argument is less than but not equal to the second argument. Equivalent to the < operator.

LESSTHANEQUAL Function

Returns true if the first argument is less than or equal to the second argument. Equivalent to the <= operator.

EQUAL Function

Returns true if the first argument is equal to the second argument. Equivalent to the = operator.

NOTEQUAL Function

Returns true if the first argument is not equal to the second argument. Equivalent to the <> or != operator.

GREATERTHAN Function

Returns true if the first argument is greater than but not equal to the second argument. Equivalent to the > operator.

GREATERTHANEQUAL Function

Returns true if the first argument is greater than or equal to the second argument. Equivalent to the >= operator.

1

11

2

10

3

9

4

8

5

7

6

6

7

5

8

4

9

3

10

2

11

1

Single row formula

LESSTHAN(colA, colB)

'lt'

Single row formula

LESSTHANEQUAL(colA, colB)

'lte'

Single row formula

EQUAL(colA, colB)

'eq'

Single row formula

NOTEQUAL(colA, colB)

'neq'

Single row formula

GREATERTHAN(colA, colB)

'gt'

Single row formula

GREATERTHANEQUAL(colA, colB)

'gte'

1

11

false

false

true

false

true

true

2

10

false

false

true

false

true

true

3

9

false

false

true

false

true

true

4

8

false

false

true

false

true

true

5

7

false

false

true

false

true

true

6

6

true

false

false

true

true

false

7

5

true

true

true

false

false

false

8

4

true

true

true

false

false

false

9

3

true

true

true

false

false

false

10

2

true

true

true

false

false

false

11

1

true

true

true

false

false

false