Expression: Inequality Operators

Inequality operators are used within conditions in Logical Functions.

They can also be used to set a value according to the result. The value returned is 0.0 if the expression evaluates to false, 1.0 if the expression evaluates to true, or missing value if the answer is undefined due to missing values.

>

Greater than

 

[Cost] > 1000

[Cost] > [Revenue]

 

>=

 

Greater than or equal to

 

[Cost] >= 1000

[Cost] >= [Revenue]

 

<

 

Less than

 

[Cost] < 1000

[Cost] < [Revenue]

 

<=

 

Less than or equal to

 

[Cost] <= 1000

[Cost] <= [Revenue]

 

=

 

Equal to

 

[Cost] = 1000

[Cost] = [Revenue]

 

<>

 

Not equal to

 

[Cost] <> 1000

[Cost] <> [Revenue]

 

 

See also - Expressions Overview