Excel AND Function

This article explains how to use the Excel AND function.

Description

The Excel AND function is a logical function that you can use to determine if all of the conditions are TRUE.

Use the OR function if you can want to determine if any of the conditions in a test are TRUE.

Here is a full list of Microsoft Excel functions.

Syntax
=AND(logical_value1, [logical_value2], …)
Argument

  • logical_value1: The first logical value to evaluate.
  • logical_value2: [Optional]. The additional logical value to evaluate.

Example:     =AND(1=1, 2=4, 3=5, 2=2)

You can specify the logical values up to 255 arguments.

Example

Let’s see our examples below.

Here is our example data.

A B
1  122 210
2  202 203
3  102 279
4  122 233

Example 1:

=AND(A1<=120, B1>200)

In Example 1, the output of AND formula will be TRUE if A1 is less than or equal to 120, and B1 is greater than 200. As you can see, A1 is 122, so A1<=120 is FALSE. AND outputs TRUE only if all of the conditions (logigcal_value1, logical_value2) are TRUE. The output of the AND formula above is FALSE.

Example 2:

=AND(A3>90, B2>200)

In Example 2, AND formula will be TRUE if A3 is greater than 90 and B2 is greater than 200. As you can see, A3 is 102, and B2 is 203, so both A3>90 and B2>200 are TRUE. The output of AND formula above is TRUE.

In this article, you learned how to use the Excel AND function. Use the Excel AND function to determine if all of the conditions are TRUE.