You can use the following basic syntax to use the **IF** and **AND **functions together in Google Sheets to determine if some cell meets several criteria:

=IF(AND(A1="String", B1>10), "value1", "value2")

If the value in cell A1 is equal to “String” *and *if the value in cell B1 is greater than 10, then we return value1, otherwise we return value2.

Note that we can use as many logical comparisons as we’d like within the **AND** function.

The following examples show how to use this syntax in practice.

**Related:** How to Combine the IF and OR Functions in Google Sheets

**Example 1: Combine IF and AND Functions with String Comparisons**

Suppose we have two columns in Google Sheets that contain the conference and number of wins for various NBA teams:

Suppose we classify a team as “Good” if they have more than 40 wins.

We can use the following formula with the **IF** and **AND **functions to determine if each team is in the West *and* Good:

=IF(AND(A2="West", B2>40), "Yes", "No")

The following screenshot shows how to use this syntax in practice:

If a given team is in the West *and* they have more than 40 wins, we return a value of “Yes”, otherwise we return “No.”

**Example 2: Combine IF and AND Functions with Numeric Comparisons**

Suppose we have columns that contain the number of points and assists for various basketball players and we’d like to classify each player as “Good” or “Bad.”

Let’s say that if a player has more than 20 points *and *more than 5 assists, we will classify them as “Good”, otherwise we’ll classify them as “Bad.”

We can use the following formula with the **IF** and **AND **functions to determine if each player should be classified as “Good” or Bad”:

=IF(AND(A2>20, B2>5), "Good", "Bad")

The following screenshot shows how to use this syntax in practice:

If a given player has more than 20 points *and *more than 5 assists, we classify them as “Good.”

Otherwise we classify them as “Bad.”

**Additional Resources**

The following tutorials explain how to perform other common operations in Google Sheets:

How to Use COUNTIF with Multiple Ranges in Google Sheets

How to Use SUMIF with Multiple Columns in Google Sheets

How to Sum Across Multiple Sheets in Google Sheets