You can use the following basic syntax to write multiple IF statements in one cell in Google Sheets:

=IF(A2<10, "Bad", IF(A2<20, "Okay", IF(A2<30, "Good", "Great")))

Here’s what this syntax does:

- If the value in cell A2 is less than 10, return the value “Bad”
- Otherwise, if the value in cell A2 is less than 20, return the value “Okay”
- Otherwise, if the value in cell A2 is less than 30, return the value “Good”
- Otherwise, return the value “Great”

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

**Example 1: Use Multiple IF Statements in Google Sheets**

Suppose we have the following column in Google Sheets that shows the points scored by various basketball players:

We can use the following syntax to write multiple IF statements to classify the players as “Bad”, “Okay”, “Good”, or “Great”:

=IF(A2<10, "Bad", IF(A2<20, "Okay", IF(A2<30, "Good", "Great")))

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

Each player receives a classification based on their number of points scored.

**Example 2: Use IFS Function in Google Sheets**

An easier way to write multiple IF statements is to simply use the **IFS** function.

We can use the following syntax to write an **IFS** statement to classify the players as “Bad”, “Okay”, “Good”, or “Great”:

=IFS(A2<10, "Bad", A2<20, "Okay", A2<30, "Good", A2>=30, "Great")

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

This produces the same results as the previous example.

Notice that this syntax is much easier to write because we don’t have to write several nested IF statements.

**Additional Resources**

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

Google Sheets: How to Use COUNTIF with Multiple Ranges

Google Sheets: How to Use SUMIF with Multiple Columns

Google Sheets: How to Check if Value is in Range