When searching in a numeric field (see Find/Select Dialog) there are over a dozen options for determining whether data is a match.

Is Equal to (=) — Any data cell that exactly matches the match value will be identified as a match.

Is Not Equal to (≠) — Any data cell that does not exactly match the match value will be identified as a match.

Is Between — Any data cell that contains a value between or equal to the two specified match values will be identified as a match. For example between 3 and 5 would include 3, 4 and 5 but would not include 2 or 6.

Is Not Between — Any data cell that contains a value outside the two specified match values will be identified as a match.

Is Less Than (<) — Any data cell that is less than the value in the box on the right will be identified as a match.

Is Greater Than (>) — Any data cell that is greater than the match value will be identified as a match.

Is Less Than or Equal to (≤) — Any data cell that is less than or equal to the match value will be identified as a match.

Is Greater Than or Equal to (≥) — Any data cell that is greater than or equal to the match value will be identified as a match.

Is Near (10%) to — Any data cell that is within plus or minus 10% of the specified will be identified as a match.

Is Not Empty — Any data cell that contains a value (even zero) will be identified as a match.

Is Empty — Any data cell that does not contain a value will be identified as a match. In other words, this option locates completely blank fields.

Is an Integer — Any data cell that contains an integer value will be identified as a match. For example, 1, 2, 45 and 5,687 would match but 1.27, 9.87 and 764.12 would not.

Is a Multiple of — Any data cell that is a multiple of the specified value will be identified as a match. For example if you specify 2 then 2, 4, 6, 8, etc. would match, while any other numbers would not.


See Also


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0