AND
TheAND
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:
 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 theAND
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.
Related Formulas
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 asAND
, 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.