Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Comparison Operators

The following comparative operators can be set under Condition in the Standard Filter dialogue box.

Comparative operator Effect
Equal (=) Shows values equal to the condition.
Less than (<) Shows values less than the condition.
Greater than (>) Shows values greater than the condition.
Less than or equal to (< =) Shows values that are less than or equal to the condition.
Greater than or equal to (> =) Shows values that are greater than or equal to the condition.
Not equal (< >) Shows the values not equal to the condition.
Largest Shows the N (numeric value as parameter) largest values.
Smallest Shows the N (numeric value as parameter) smallest values.
Largest % Shows the largest N% (numeric value as parameter) of the total values.
Smallest % Shows the smallest N% (numeric value as parameter) of the entire values.