How to use Relational Operators

 

Relational Operators are functions which compare two values.

 

•     If they are true, the value is returned as 1.

•     If they are false, the value is returned as 0.

 

Operator

Definition

< 

Is less than

1.0<2.0, return the value 1

2.0<1.0, return the value 0

<=

Is less than or equal to

1.0<=2.0, return the value 1

2.0<=1.0, return the value 0

=

Is equal to

A=B, return the value 1( If |A-B|<IF Tolerance)

A=B, return the value 0( If |A-B|>=IF Tolerance)

> 

Is greater than

1.0>2.0, return the value 0

2.0>1.0, return the value 1

>=

Is greater than or equal to

1.0>=2.0, return the value 0

2.0>=1.0, return the value 1

<> 

Is not equal to

A<>B, return the value 0( If |A-B|<IF Tolerance)

A<>B, return the value 1( If |A-B|>=IF Tolerance)

 

•     IF Tolerance

To see the information of IF Tolerance, refer to How to use Arithmetic IF Function.