How to Use an IF Function with 3 Conditions in Excel

Using an IF function with 3 conditions in Excel requires nested IF functions. The nested IF function allows you to check multiple conditions and return different values or perform different calculations based on each condition.

Here is how to create a nested IF function with 3 conditions in Excel:

1. Open Microsoft Excel and click on a cell where you want the result of the IF function to be displayed.
2. Start by typing the "=IF(" formula in the selected cell.
3. Enter the first condition. This is a logical test that checks if a specific condition is met, e.g., (A1 > B1).
4. Type a comma and enter the value or formula you want to return if the first condition is met, e.g., "Condition 1 met".
5. Type a comma and start the second IF function by typing "IF(".
6. Enter the second condition, e.g., (A1 = B1).
7. Type a comma and enter the value or formula you want to return if the second condition is met, e.g., "Condition 2 met".
8. Type a comma and start the third IF function by typing "IF(".
9. Enter the third condition, e.g., (A1 < B1).
10. Type a comma and enter the value or formula you want to return if the third condition is met, e.g., "Condition 3 met".
11. To close the third IF function, type a comma and enter the value or formula you want to return if none of the conditions are met, e.g., "No conditions met".
12. Close the third IF function with a parenthesis ")".
13. Close the second IF function with a parenthesis ")".
14. Close the first IF function with a parenthesis ")".
15. Press Enter to complete the formula. The result will be displayed in the selected cell based on the conditions and values provided.

Example

Let's say you want to determine the performance of a student based on their score. Here's an example of how to use the nested IF function with 3 conditions:

1. Enter the student's score in cell A1.
2. Click on cell B1, where you want the result of the IF function to be displayed.
3. Type the following formula in cell B1:

=IF(A1>=90,"Excellent",IF(A1>=70,"Good",IF(A1>=50,"Average","Poor")))

4. Press Enter to complete the formula. The result will be displayed in cell B1 based on the score in cell A1. If the student's score is greater than or equal to 90, the result will be "Excellent". If the student's score is greater than or equal to 70 but less than 90, the result will be "Good". If the student's score is greater than or equal to 50 but less than 70, the result will be "Average". If the student's score is less than 50, the result will be "Poor".