How to Use the AND Function in Excel

The AND function in Excel and Google Sheets is a logical function that returns TRUE if all provided arguments are TRUE, and FALSE if any one of them is FALSE. This function is frequently used in combination with other functions or with conditional formatting to execute tasks based on multiple criteria.

Excel Syntax

In Microsoft Excel, the syntax for the AND function is:

=AND(logical1, [logical2], ...)
  • logical1, logical2, … represent the conditions that are being tested.
  • The function returns TRUE only if every specified condition evaluates to TRUE.

Google Sheets Syntax

The syntax for the AND function in Google Sheets is identical to that in Excel:

=AND(logical1, [logical2], ...)

Examples

Here are some practical examples illustrating how to use the AND function:

Example 1: Check if Both Conditions are Met

Assuming you have conditions specified in cells A1 and B1, and you need to check if both are TRUE, you can employ the AND function as follows:

A B Result
TRUE TRUE =AND(A1 = TRUE, B1 = TRUE)

The result will be TRUE only if both A1 and B1 indeed contain the value TRUE.

Example 2: Multiple Conditions

The AND function can check several conditions concurrently. For example, to verify that three conditions are met:

A B C Result
10 20 30 =AND(A1 > 0, B1 > 0, C1 > 0)

This formula returns TRUE only if all three values exceed 0.

Example 3: Using AND with IF Function

The AND function can be amalgamated with the IF function for more intricate logical tests. For instance:

=IF(AND(A1 = "Yes", B1 > 10), "Qualified", "Not Qualified")

Here, the result will be “Qualified” if A1 contains “Yes” and B1 is greater than 10; otherwise, it will display “Not Qualified”.

These instances showcase the flexibility of the AND function in Excel and Google Sheets for evaluating complex, multi-condition scenarios.

More information: https://support.microsoft.com/en-us/office/and-function-5f19b2e8-e1df-4408-897a-ce285a19e9d9

Other functions
Returns the logical value FALSE
Specifies a logical test to perform
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression
Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition
Reverses the logic of its argument
Returns TRUE if any argument is TRUE
Evaluates an expression against a list of values and returns the result corresponding to the first matching value If there is no match, an optional default value may be returned
Returns the logical value TRUE
Returns a logical exclusive OR of all arguments