How to use AND Google Sheets formula?

The syntax for the AND formula is =AND(logical_expression1, [logical_expression2, ...]), it has 1 required parameter and 1 optional parameter.

AND

The AND function in Google Sheets is a logical function that returns TRUE if all of the logical expressions in the argument are TRUE, and FALSE if any of the logical expressions are FALSE. It can be used to test multiple conditions and evaluate whether they are all true or not.

How to use AND formula?
Examples of using AND formula
AND formula not working?
Similar formulas to AND

Usage

Use the AND formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:

=AND(logical_expression1, [logical_expression2, ...])

Parameters:

logical_expression1 (required):
The first logical expression that you want to test.
logical_expression2, ... (optional):
Additional logical expressions that you want to test, up to a maximum of 255. Separate each logical expression by a comma.

Examples

Here are a few example use cases that explain how to use the AND formula in Google Sheets.

Check if multiple conditions are true

You can use the AND function to check if multiple conditions are true. For example, you might use it to determine whether a student has passed a test based on their score and attendance.

Combine with other logical functions

You can combine the AND function with other logical functions, such as OR and NOT, to create more complex logical expressions.

Filter data based on multiple criteria

You can use the AND function to filter data in Google Sheets based on multiple criteria. For example, you might use it to filter a list of students based on their grade level and their attendance record.

Common Mistakes

AND not working? Here are some common mistakes people make when using the AND Google Sheets Formula:

Incorrect Syntax

One of the logical expressions is missing or there is an extra comma. Check that all logical expressions are included and separated by commas.

Incorrect Arguments

The AND formula only returns a TRUE or FALSE result. Check that the logical expressions are written correctly and evaluate to TRUE or FALSE.

Misunderstanding of Logic

Some users may not understand how the AND formula works and may use it incorrectly. Make sure to read the documentation and understand how the formula evaluates the logical expressions.

The following functions are similar to AND or are often used with it in a formula:

OR
The OR formula is a logical formula that returns TRUE if at least one of the provided logical expressions is TRUE. It returns FALSE if all logical expressions are FALSE. This formula is commonly used in conjunction with other logical formulas, such as AND, to build more complex logical statements.
NOT
The NOT formula in Google Sheets is a logical function that negates a given logical expression. If the logical expression evaluates to TRUE, the formula returns FALSE, and vice versa. This function is commonly used to reverse the result of a logical test, or to check if a value is not equal to a specific criteria.
IF
The IF formula is a logical function used to test a condition and return one value if the condition is true and another value if the condition is false. It is commonly used to create conditional statements and perform calculations based on certain conditions.
FILTER
The FILTER formula in Google Sheets is used to filter a range of data based on specified conditions. It returns a new range that only includes the rows that meet the specified conditions. This formula is commonly used to extract specific data from a larger dataset.
COUNTIF
The COUNTIF formula counts the number of cells within a specified range that meet a certain criterion. This formula is commonly used to count cells that meet a specific condition or criteria.

Learn More

You can learn more about the AND Google Sheets function on Google Support.

AND