The AND Function
With the AND function, you can specify a number of conditions (up to 255) and receive a value of TRUE if all of the conditions are met. If even one of the specified conditions is not met, the AND function will return a value of FALSE.
As an example, let’s suppose that we have a spreadsheet containing data for an apartment complex that lists the year, make, and color of each resident’s vehicle. The screenshot below shows how the information has been entered into the spreadsheet. (Click the image for a larger view.)
Using this data, we want to find out how many vehicles are black in color and made by Ford. We can use the following AND function to determine which vehicles meet both these conditions.
Entering this formula into the first empty cell of the Black Ford column yields the result shown below.
If we copy (or "fill down") the function into the other cells of the column, we can see that the value of TRUE is returned for each row in which the Vehicle Color is black and the Vehicle Make is Ford. All other rows return a value of FALSE.