If this OR that

There are two special functions, AND and OR, that make this easy to do.

Let’s take a look.

In this first worksheet, we have a list of employees.

Let’s assume that you oughta group these employees into two groups.

Start off normally with IF and an open parentheses.

If any test returns TRUE, the OR function will return TRUE.

Then I end the parentheses for OR.

When I copy the formula down, we’ll see the groups we need.

Now let’s look at another example which contains a list of houses for sale.

Imagine that you have a big list and you want to quickly mark the properties you’re interested in.

In this case, we can’t use IF with OR.

We need to use IF with theAND function.

The AND function works like the OR function; simply enter each logical test separated by commas.

When I copy the formula down, you’re free to quickly see which houses meet the criteria.

Like the OR function, the AND function evaluates to a single TRUE or FALSE value.

However, unlike OR, the AND function requires that all tests return TRUE.