Using Boolean Expressions to Compare Values in Excel

By Stephen L. Nelson, E. C. Nelson

To construct a Boolean expression, such as when you filter criteria, use a comparison operator and then a value used in the comparison: (>5, for example). These are Boolean comparisons that compare two values and evaluate whether the statement is true or false.

Comparison Operator What It Means
= Equals
> Greater than
>= Greater than or equal to
< Less than
<= Less than or equal to
<> Not equal to