How to use AND Formula in Excel?

AND formula in Excel is used to return TRUE or FALSE based on two or more logical arguments. The AND formula in Excel is a part of logical formulas.

The article in this webpage describes how to use AND formula in Microsoft Excel with syntax, detailed explanation and examples.

What is AND Formula in Excel?

The AND formula in Excel returns as TRUE if all arguments evaluate to TRUE, else returns as FALSE. The Excel AND formula checks more than one logical conditions at the same time, upto a maximum of 255 conditions.

What is the Syntax of AND Formula in Excel?

The Syntax of Excel AND formula is:

=AND(logical1, [logical2], …)

What are the Arguments of AND Formula in Excel?

The Arguments of AND formula in Microsoft Excel are explained below in detail and summary for your easy reference:

Logical1 (Required Argument)

This first condition or logical value that you want to check.

Logical2, … (Optional Argument)

This additional conditions or logical values that you want to check.

Summary of AND Arguments:

• Logical1 (Required) – first condition.
• Logical2, … (Optional) – additional condition(s).

How to use AND Formula in Excel with Examples?

Example 1 (conditions)

AND formula example step by step:

• Select the cell D9 where you want to use the AND formula.
• Type equal sign = followed by AND function name and open bracket (.
• Either select the cell or type the first condition 50>25.
• Similarly define the additional conditions 100>60 and end the formula with close bracket ).
• Then hit Enter from keyboard to get the result.

=AND(50>25,100>60)

Example 2 (TRUE or FALSE)

The AND formula checks if all arguments are TRUE and results as FALSE if any one of the arguments evaluates as FALSE. In the below AND formula example, the second argument contains 100 > 60, which is not TRUE so it results as FALSE. The Excel AND formula in cell D9 is:

=AND(50>25,100>60)

Example 3 (Multiple Conditions)

Let’s understand the AND formula with multiple conditions from the below data:

=AND(C7=”Apple”,D7>10000,E7>=5000)

Result: TRUE

=AND(C8=”Mango”,D8>10000,E8>25000)

Result: FALSE

What are the Key Points for AND Formula in Excel?

You must remeber the below key points while using the AND formula in Microsoft Excel:

• The AND formula returns as #VALUE error if the argument contains no logical values.
• In AND formula all the arguments must evaluate to logical values. If any argument contains text or empty cells then those are ignored.
• The AND formula accepts upto a maximum of 255 conditions or arguments.