How to Use Multiple IF Statements in Google Sheets

To use multiple IF statements in Google Sheets, you can use the IF function in combination with other IF functions or logical functions like AND, OR. This is also known as nesting IF statements. The general syntax for a nested IF statement is:

=IF(condition1, value_if_true1, IF(condition2, value_if_true2, value_if_false))

Here are the steps to use multiple IF statements in Google Sheets:

1. Open your Google Sheets document.
2. Select the cell where you want to write the formula.
3. Start by typing the =IF( function.
4. Enter the first condition (logical expression) followed by a comma.
5. Enter the value you want to return if the first condition is true, followed by a comma.
6. Now, you can add another IF statement within the current IF statement. Type IF( and repeat steps 4 and 5 for the second condition.
7. If you have more conditions, you can continue nesting IF statements. Otherwise, enter the value you want to return if all the conditions are false.
8. Close the parentheses for each IF statement. Make sure the number of closing parentheses matches the number of opening parentheses.
9. Press Enter to apply the formula.

Example

Let's say you have a sheet with the following data:

A      B
1   Score  Grade
2   85

You want to find the grade based on the score in cell A2 using the following criteria:

• A: Score >= 90
• B: Score >= 80
• C: Score >= 70
• D: Score >= 60
• F: Score < 60

You can use multiple IF statements to determine the grade:

1. Select cell B2 to write the formula.
2. Enter the formula:

=IF(A2>=90, "A", IF(A2>=80, "B", IF(A2>=70, "C", IF(A2>=60, "D", "F"))))

3. Press Enter to apply the formula.

Now, the grade for the score in cell A2 will appear in cell B2. In this example, the grade is "B".