Comparison Operators
/text/shared/02/12090101.xhp
comparisons;operators in standard filter dialog
operators;standard filters
standard filters;comparison operators
filters; comparison operators
equal sign, see also operators
mw added "equal sign,..."MW changed "default filters;" into "standard filters;"mw changed "comparisons;" and "operators;"
Comparison Operators
The following comparative operators can be set under - Condition
in the - Standard Filter
dialog.
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.