How to Use Nested IF in Excel: Simple Guide with Examples

In Excel, you use nested IF by placing one IF function inside another to test multiple conditions in order. Each IF checks a condition and returns a result or moves to the next IF. This lets you create complex decision rules in one formula.

Syntax

The nested IF formula looks like this:

• =IF(condition1, value_if_true1, IF(condition2, value_if_true2, value_if_false2))
• condition1: The first test you want to check.
• value_if_true1: What to return if condition1 is true.
• IF(condition2, ...): Another IF function inside the first one to check a second condition if the first is false.
• value_if_false2: The final value if all conditions are false.

You can add more IF functions inside to test more conditions.

excel

=IF(A1>90, "Excellent", IF(A1>75, "Good", "Needs Improvement"))

Example

This example checks a score in cell A1 and returns a grade:

• If the score is greater than 90, it returns "Excellent".
• If the score is greater than 75 but not over 90, it returns "Good".
• If the score is 75 or less, it returns "Needs Improvement".

excel

=IF(A1>90, "Excellent", IF(A1>75, "Good", "Needs Improvement"))

Output

If A1=92 → "Excellent"
If A1=80 → "Good"
If A1=70 → "Needs Improvement"

Common Pitfalls

Common mistakes when using nested IF include:

• Forgetting to close all parentheses, which causes errors.
• Mixing up the order of conditions, so the formula returns wrong results.
• Making the formula too long and hard to read.
• Not using absolute references when copying formulas, causing wrong cell references.

Example of a wrong formula missing a parenthesis:

excel

=IF(A1>90, "Excellent", IF(A1>75, "Good", "Needs Improvement"))

Output

Error: Missing closing parenthesis

Quick Reference

Part	Description	Example
IF	Tests a condition	IF(A1>90, ...)
condition	What you want to check	A1>90
value_if_true	Result if condition is true	"Excellent"
value_if_false	Result if condition is false or next IF	IF(A1>75, "Good", "Needs Improvement")
Nested IF	IF inside another IF to test more conditions	IF(A1>90, "Excellent", IF(A1>75, "Good", "Needs Improvement"))

Key Takeaways

Use nested IF to test multiple conditions in order within one formula.

Always close all parentheses to avoid formula errors.

Order your conditions from most specific to least specific for correct results.

Keep nested IF formulas simple to maintain readability.

Use absolute references if copying formulas to other cells.