Nested IF Formula Generator
Nested IF formulas let you test multiple conditions and return different values for each. They're commonly used for grading scales, tiered pricing, and status categorization.
Syntax
=IF(condition1, value1, IF(condition2, value2, IF(condition3, value3, default)))Try it — generate a Nested IF formula
Examples
Letter grade from score
=IF(B2>=90,"A",IF(B2>=80,"B",IF(B2>=70,"C",IF(B2>=60,"D","F"))))Assigns letter grades: A for 90+, B for 80-89, C for 70-79, D for 60-69, F below 60.
Shipping tier
=IF(C2>100,"Free",IF(C2>50,"$5.99","$9.99"))Free shipping over $100, $5.99 for $50-100, $9.99 under $50.
Tips
- ✓In Google Sheets, consider using IFS() instead — it's cleaner for multiple conditions.
- ✓Always test from highest to lowest (or vice versa) to avoid logic errors.
- ✓For more than 4-5 levels, consider using VLOOKUP with a reference table instead.
Related Formulas
FILTER
FILTER returns rows from a range that meet specified conditions. It's like AutoF...
SUMIFS
SUMIFS adds up values that meet multiple criteria. It's essential for financial ...
XLOOKUP
XLOOKUP is the modern replacement for VLOOKUP and HLOOKUP. It can search in any ...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free