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."
Syntax guide.
Parameters
The first condition to test.
The value returned if the first condition is TRUE.
The second condition to test.
The value returned if the second condition is TRUE.
Use TRUE to create a catch-all default condition.
The default value if no prior conditions are met.
Interactive formula builder.
Fill in the input arguments below to construct your custom formula string. Copy it directly to paste into your Excel spreadsheets.
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 Gotchas
- 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).