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 |
dummies
Source:http://www.dummies.com/how-to/content/using-boolean-expressions-in-data-analysis-with-ex.html
No comments:
Post a Comment