If you have more than one condition, and each condition applies to a different field, you still use the or cells. For example, you use this technique to find customers in either France or London.
Start by entering the first condition in the Criteria
cell. In this case, it's France.
Because you need to find France or
London, enter the second criteria in the Or
field, like so.
Next, we'll look at the differences between the And and Or operators.