Range Parameters
Use the range parameters to specify which values
the inspected cells must contain to satisfy the data query. You can
set separate limits for real numbers and strings. The range parameters
apply after determining which cells to inspect.
The following table contains the range operators for numeric data, the limits, and the results. For a complete list of range operators, see the IBM®.
| Operator |
Limits |
Results |
|---|---|---|
| All |
Blank |
All cell values |
| = a |
a = 200 |
Cell values of 200 |
| > = a |
a = 200 |
Cell values greater than or equal to 200 |
| < = a |
a = 200 |
Cell values less than or equal to 200 |
| > a |
a = 200 |
Cell values greater than 200 |
| < a |
a = 200 |
Cell values less than 200 |
| < > a |
a = 200 |
Cell values less than or greater than 200 |
| > = a & < = b |
a = 200 b = 1200 |
Cell values in the range 200-1200 |
| > a & < b |
a = 200b = 1200 |
Cell values in the range 201-1199 |