How it works.
The IFS function evaluates multiple conditions in order and returns the value corresponding to the first condition that is TRUE. This is much cleaner to write and read than nested IF statements.
💡 In simple terms.
Checks multiple conditions in order and returns the grade/value matching the first true condition.
"Think of this like a grading machine checking grades in order: IF score is 90+ print A, IF 80+ print B, IF 70+ print C, otherwise print F."
Formula syntax.
Standard Excel Notation=IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)[like_this] are optional; all other arguments are required.Formula arguments.
Every parameter accepted by the IFS function is detailed below.
The first condition to test.
Example value:C2>=90The value returned if the first condition is TRUE.
Example value:"A"The second condition to test.
Example value:C2>=80The value returned if the second condition is TRUE.
Example value:"B"Use TRUE to create a catch-all default condition.
Example value:TRUEThe default value if no prior conditions are met.
Example value:"F"Simple example.
Step-by-Step ScenarioScore Grade Labeler
Assign grades A, B, C, or F based on scores.
| Name | Subject | Score | Grade | Scale |
|---|---|---|---|---|
| Bella | Science | 92 | — | 90+ = A |
| Caleb | Science | 81 | — | 80+ = B |
| Dylan | Science | 74 | — | 70+ = C |
=IFS(C2>=90, "A", C2>=80, "B", C2>=70, "C", TRUE, "F")Evaluates IFS over the sample table cells, placing the verified output in cell D2:D6.
Formula generator.
Full Generator WizardCustomize the argument fields below to generate a tailored IFS formula ready to paste directly into your worksheet.
=IFS()Expected result behavior.
Returns "Calculated output" based on sample evaluation criteria and active cell references.
Best Practices
- Always add a final condition of TRUE as a catch-all default at the end of the argument list (e.g. TRUE, "Other") so the formula doesn't return #N/A if no conditions match.
Common Mistakes
- IFS evaluates conditions from left to right. Make sure your conditions are in the correct order (e.g. start with >90, then >80, then >70).
Platform & version compatibility.
Verified platform compatibility matrix based on actual spreadsheet calculation engine specifications.
In Excel 2016 or older, nest standard IF formulas: =IF(c1, v1, IF(c2, v2, v3)).
Introduced in Excel 2019 and Excel 365. Supported in Excel 2019, 2021, and 365.
100% compatible with Google Sheets with identical condition/value syntax pairs.
Frequently asked questions.
Technical Q&ACan I use IFS across different worksheets in Excel?↓
Yes. You can reference cells located on other sheets by including the sheet name followed by an exclamation mark, for example: =IFS(Sheet2!A2:A10). If the sheet name contains spaces, enclose it in single quotes: ='Q1 Report'!A2:A10.
What is the most common reason for errors in IFS?↓
IFS evaluates conditions from left to right. Make sure your conditions are in the correct order (e.g. start with >90, then >80, then >70).
Does IFS work identically in Google Sheets?↓
Yes, IFS is supported in both Microsoft Excel and Google Sheets with standard evaluation behavior.