Logical Function: AND

This logical function is important when doing advanced work in Excel because it can help you control the behavior of your worksheets based on specific logical conditions.

The AND function will return true if all of its arguments are true. If one argument is false, the AND function will return false. For example, the logical statement 1<10 is true, and the statement 2>1 is also true. As a result, the compound statement 1<10 AND 2>1 is true, because both of the statements that are being joined by AND are true:

Notice that the arguments joined by AND are placed in parentheses and separated by commas. The Excel function =AND(1<10, 2>1) means the exact same thing as saying 1<10 AND 2>1 in plain English. Because 1 is less than 10 and 2 is greater than 1, the Excel AND function returns the logical value True.

The following table (called a truth table) may help you understand the AND function. In the last column of the truth table, you will see the value returned by the function according to the corresponding values of the function arguments.

This function can be a lot of help either by applying directly to the worksheet to come up with the desired data based on the conditions or applying in other features like Conditional Formatting.