How to Use IFS in Excel (Multiple IF Conditions + Free Generator)

Checks multiple conditions and returns a value corresponding to the first TRUE condition. Cleaner than nested IFs.

Generated Formula
=IFS(condition1, value1, condition2, value2, condition3, value3)

Learning Resources

Want to master Excel? Check out this Top-Rated Course.

How to Use IFS in Excel — Step by Step

The IFS function checks multiple conditions in order and returns the value for the first TRUE test. It is ideal for letter grades, tiered discounts, and commission bands — without stacking IF(IF(IF(...))).

Real-World Example: Student Letter Grades

Imagine you have student scores in column A and want to assign letter grades in column B:

A (Score)B (Formula)Result
95=IFS(A2>=90,"A",A2>=80,"B",A2>=70,"C",A2>=60,"D",TRUE,"F")A
82(same formula)B
67(same formula)D
41(same formula)F

The formula checks from highest threshold to lowest. If no condition matches, the TRUE fallback returns "F".

IFS vs Nested IF — Comparison

FeatureIFSNested IF
Syntax=IFS(test1, val1, test2, val2)=IF(test1, val1, IF(test2, val2, ...))
ReadabilityFlat, easy to scanDeeply nested, hard to read
Limit127 conditions (Excel 2019+)7 levels deep (Excel 2003) or 64 (Excel 2007+)
Default valueMust add TRUE fallback manuallyLast FALSE value works as default
CompatibilityExcel 2019+ / Microsoft 365 / SheetsAll versions

Common Mistakes with IFS

  • No TRUE fallback — If no condition matches, IFS returns #N/A. Always add TRUE, "Default" as the last pair.
  • Wrong condition order — IFS stops at the first TRUE. Place the most specific (highest threshold) conditions first.
  • Text vs number mismatch — Comparing text "90" to the number 90 fails. Use VALUE() to convert text scores.
  • Empty cells treated as 0 — A blank cell evaluates as 0 in comparisons. Use ISBLANK() as an early condition if needed.

Minimum Viable Pattern

Always end with a catch-all: use TRUE as the last condition to assign a default (e.g. "F" or "Other").

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

Google Sheets & Excel Compatibility

IFS works in Excel 2019+ / Microsoft 365 and Google Sheets. For older Excel, use nested IF or lookup tables.

Pro Tip: For tiered pricing or commission rates, combine IFS with LOOKUP tables. Store your thresholds in a separate range and reference them with named ranges — your formulas stay clean and your business logic lives in one place.

Common Errors & Fixes

  • #N/A or wrong grade bucket

    Causes:
    • Conditions out of order so a lower threshold matches first.
    • Missing TRUE fallback.
    • Comparing text scores without VALUE().
    Fixes:
    • Put highest thresholds first.
    • End with TRUE, "default".
    • Use VALUE(A1) if scores are stored as text.

Frequently Asked Questions

Can IFS replace nested IF for letter grades?

Yes. Example: =IFS(A1>=90,"A",A1>=80,"B",A1>=70,"C",TRUE,"F"). Easier to read than multiple nested IFs. The TRUE fallback ensures every score gets a grade.

Why does IFS return #N/A?

No condition matched and there is no final TRUE fallback. Add TRUE, "Default" as the last pair. This is the most common IFS mistake — always plan for unmatched values.

IFS vs SWITCH — which should I use?

IFS tests ranges and inequalities (e.g. A1>=90); SWITCH matches exact values (e.g. A1="Red"). Use IFS for grade bands, tier thresholds, and date ranges. Use SWITCH for exact category mapping.

Can I use IFS with dates?

Yes. Example: =IFS(A1>TODAY(),"Future",A1=TODAY(),"Today",A1

What Excel versions support IFS?

IFS is available in Excel 2019, Excel 2021, Microsoft 365 (Office 365), and Google Sheets. It is not available in Excel 2016 or earlier — use nested IF instead.

How many conditions can IFS handle?

Excel 2019+ supports up to 127 condition/value pairs. Google Sheets has a practical limit of about 50 pairs. For complex logic, consider using a lookup table instead.

Why is my IFS formula returning wrong results?

Most likely your conditions are in the wrong order. IFS returns the value for the first TRUE condition, so place the most specific condition first. Also check for text-vs-number mismatches: "90" (text) is not >= 90 (number). Use VALUE() to convert.

Can I use AND/OR inside IFS conditions?

Yes. Wrap multiple criteria in AND or OR: =IFS(AND(A1>=90,B1="Pass"),"Honors",A1>=70,"Pass",TRUE,"Fail"). This lets you build complex multi-column logic within a single IFS condition.

Related Formulas

Explore related formula generators to solve similar problems

IFIFERRORSUMIFSAVERAGEIFCOUNTIF

🛠️ Related Tools

Formula Comparator

Compare Excel formulas side by side

Remove Duplicates

Clean duplicate values from your data

GPA Calculator

Weighted & unweighted grade point average

SUMIFS Across Sheets

Sum across multiple Excel sheets

Want to become an Excel Pro?

Stop searching for formulas. Master Excel in 30 days with this top-rated course.

Learn More