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

Notes 

You can also use <> for Not Equal To (), >= for Greater Than or Equal To (), and <= for Less Than or Equal To ().

Related topics 

About formulas