Nested IF Function in Excel: Syntax, Examples and Free Practice
Nested IF is an Excel Logical function. Chains multiple IF functions together to test several conditions in order and return different results for each.
Nested IF syntax
Arguments
condition1: First condition to testresult1: Result if condition1 is TRUEcondition2: Second condition, checked only if condition1 is FALSE
When to use Nested IF
Assigning a grade (A/B/C/D) based on which score range a value falls into.
Practice Nested IF online, free
Open the live Excel-style spreadsheet and try Nested IF yourself. No Excel install or sign-up needed to start.
Practice Nested IF now →More Logical functions
- IF + AND
- Nested IF (3 levels)
- IF + AND + OR (combined)
- IFS + AND
- IF + ISERROR
- IF + ISBLANK
- IF + OR
- IF + ISNUMBER
- IF + TODAY
- IF + VLOOKUP (conditional lookup)
- Nested IF + VLOOKUP (tiered lookup)
- IF + LEN (input validation)
- VLOOKUP + ISERROR (existence check)
Frequently asked questions
What does the Nested IF function do in Excel?
Chains multiple IF functions together to test several conditions in order and return different results for each.
What is the syntax of Nested IF in Excel?
The syntax is =IF(condition1, result1, IF(condition2, result2, result3)). condition1: First condition to test; result1: Result if condition1 is TRUE; condition2: Second condition, checked only if condition1 is FALSE.
Where can I practice Nested IF online for free?
Open the free live spreadsheet on Cellgrids and try Nested IF yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Logical functions · Excel case studies · Excel tutorials · Excel shortcuts