Go to Contents  
Contents > Comparison operators
Comparison operators
Comparison operators compare two values and return either True or False. (Such expressions are sometimes called Boolean expressions.) Mathematically, a result of True equals 1 and False equals 0.
Symbol Name Definition
=
Equals
True if the items are equal
≠
Not Equal to
True if the items are not equal
>
Greater Than
True if the value on the left exceeds that on the right
<
Less Than
True if the value on the left is less than the value on the right
≥
Greater Than or Equal To
True if the value on the left is greater than or equal to the value on the right
≤
Less Than or Equal To
True if the value on the left is less than or equal to the value on the right
Note   You can also use <> for Not Equal To (≠), >= for Greater Than or Equal To (≥), and <= for Less Than or Equal To (≤).
Related topic
About formulas

Contents > Comparison operators