How to Use Multiple IF Statements in Google Sheets


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:

Multiple IF statements in Google Sheets

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

Leave a Reply

Your email address will not be published.