When you are using the Normal view of the Filter or Edit Category dialog box, the lower part of the right side of the dialog box lists the conditions that have been defined already. Multiple conditions are combined with:

In addition you may want to use the Not operator to negate conditions and use parentheses (( )) to change the order in which the conditions are evaluated.

Each condition is shown on a separate line. To change a condition, click in the following column on the line you want to change:

Click And or Or to add or replace the existing operator. Combine conditions with the And operator when you want cases to be selected if they satisfy both conditions. Combine conditions with the Or operator when you want cases to be selected if they satisfy either or both of the conditions. Note that you cannot begin the first line of an expression with And or Or.

Click Not to negate the condition, or blank to remove the existing negation.

Click Add to insert a new opening parenthesis on the selected line, or Remove to delete an existing parenthesis. You typically use parentheses in complex expressions to change the order in which the conditions are evaluated. See Operator precedence for more information.

Click Add to insert a new closing parenthesis on the selected line, or Remove to delete an existing parenthesis. You typically use parentheses in complex expressions to change the order in which the conditions are evaluated. See Operator precedence for more information.