Excel Function: AND

The Excel function AND checks if all tests are TRUE and returns FALSE if one or more tests are FALSE.

This function is usually used in combination with other functions (as in the following example with the function IF).


=AND(test_1, test_2, etc)

Example of use

The goal here is to check if the user is registered for course A AND course C:

excel function and

Start by selecting the IF function and enter the Value_if_true and Value_if_false:

excel function and if

Now click in Logical_test and select the AND function from the drop-down list:

excel function and if nesting

Finally, enter the tests to be performed:

excel function and multiple tests

The formula therefore returns "Yes" because all tests are TRUE:

excel function and tests

Then stretch the formula to apply it to the other cells:

excel function and tests values
If needed, you can download the Excel file used here: and.xlsx