Nested IF (3 levels) Function in Excel: Syntax, Examples and Free Practice
Nested IF (3 levels) is an Excel Logical function. Chains three IF checks in a row to sort a value into one of four categories.
Nested IF (3 levels) syntax
Arguments
cond1: First conditionresult1: Result if cond1 is TRUEcond2: Second condition, checked only if cond1 is FALSE
When to use Nested IF (3 levels)
Assigning a shipping tier (Same Day/Next Day/Standard/Economy) based on order value.
Practice Nested IF (3 levels) online, free
Open the live Excel-style spreadsheet and try Nested IF (3 levels) yourself. No Excel install or sign-up needed to start.
Practice Nested IF (3 levels) now →More Logical functions
- IF + AND
- Nested IF
- 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 (3 levels) function do in Excel?
Chains three IF checks in a row to sort a value into one of four categories.
What is the syntax of Nested IF (3 levels) in Excel?
The syntax is =IF(cond1, result1, IF(cond2, result2, IF(cond3, result3, result4))). cond1: First condition; result1: Result if cond1 is TRUE; cond2: Second condition, checked only if cond1 is FALSE.
Where can I practice Nested IF (3 levels) online for free?
Open the free live spreadsheet on Cellgrids and try Nested IF (3 levels) 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