Using Boolean Expressions in Data Analysis with Excel 2007

By Stephen L. Nelson

Part of Excel 2007 Data Analysis For Dummies Cheat Sheet

Excel 2007 data analysis tools include Boolean expressions, of course. To construct a Boolean expression, such as when you filter criteria, use a comparison operator and then a value in the comparison (>5, for example). The following table shows the Excel comparision operators and what they represent:

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