Using Boolean Expressions in Data Analysis with Excel 2007

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 OperatorWhat It Means
=Equals
>Greater than
>=Greater than or equal to
<Less than
<=Less than or equal to
<>Not equal to








dummies

Source:http://www.dummies.com/how-to/content/using-boolean-expressions-in-data-analysis-with-ex.html

No comments:

Post a Comment