Guida Excel

How to write nested IF formulas in Excel

Nested IF formulas allow you to test multiple conditions by placing one IF function inside another. For complex logic, the IFS function offers a cleaner, more readable alternative.

Fallo con l'IA

Passo passo

1
Start the first IF function
Select the target cell and type '=IF(logical_test, value_if_true, '
2
Insert the nested IF
Instead of a final value, type another 'IF(' function in the 'value_if_false' argument slot.
3
Close all parentheses
Ensure you add a closing parenthesis for every IF function opened, then press Enter.
4
Switch to IFS for readability
If you have more than three conditions, use '=IFS(condition1, value1, condition2, value2, ...)' to avoid complex nesting.

=IF(A1>=90, "A", IF(A1>=80, "B", IF(A1>=70, "C", "F")))

Suggerimenti

Always test your conditions from most specific to least specific to avoid logic errors.
Use Alt + Enter to add line breaks inside the formula bar to make nested formulas easier to read.

Domande frequenti

How many IF functions can I nest?

Excel allows up to 64 nested IF functions, though it is highly recommended to use IFS or VLOOKUP for readability.