How to Use an IF Function with 3 Conditions in Google Sheets

To use an IF function with 3 conditions in Google Sheets, you'll need to nest multiple IF statements within each other. Here's a step-by-step guide on how to do this:

1. Open your Google Sheets document.
2. Click on a cell where you want to display the result of the IF function.
3. Type the following formula:

=IF(condition1, value_if_true1, IF(condition2, value_if_true2, IF(condition3, value_if_true3, value_if_false3)))

4. Replace condition1, condition2, and condition3 with your respective conditions. You can use logical expressions, cell references, or other functions as conditions.
5. Replace value_if_true1, value_if_true2, and value_if_true3 with the values or calculations you want to return if the respective condition is true.
6. Replace value_if_false3 with the value or calculation you want to return if none of the conditions are true.
7. Press Enter to apply the formula. The result will be displayed in the selected cell.

Example

Let's say you have a list of students and their test scores, and you want to classify them into categories based on their scores. The categories are:

• Excellent: score >= 90
• Good: score >= 75 and score < 90
• Average: score >= 50 and score < 75
• Poor: score < 50

Here's how you would use an IF function with 3 conditions to categorize the students:

1. In your Google Sheets document, click on a cell where you want to display the category for the first student.
2. Type the following formula:

=IF(B2 >= 90, "Excellent", IF(B2 >= 75, "Good", IF(B2 >= 50, "Average", "Poor")))

In this example, B2 is the cell containing the test score of the first student.

3. Press Enter to apply the formula. The category for the first student will be displayed in the selected cell.
4. To apply the formula to the other students, click on the bottom-right corner of the cell with the formula and drag it down the column.

The IF function will now categorize each student based on their test score according to the specified conditions.