IFS Function Generator
IFS evaluates conditions in order and returns the value for the first TRUE. Cleaner than nested IFs. Available in Excel 2019+, Excel 365, and Google Sheets.
Syntax
=IFS(condition1, value1, [condition2, value2, ...])Try it — generate a IFS formula
Examples
Grade from score
=IFS(A2>=90,"A", A2>=80,"B", A2>=70,"C", A2>=60,"D", TRUE,"F")TRUE at the end acts as a default catch-all.
Aging buckets
=IFS(B2<=30,"0-30", B2<=60,"31-60", B2<=90,"61-90", TRUE,"90+")Order matters — first TRUE wins.
Size tier
=IFS(A2<100,"Small", A2<1000,"Medium", A2<10000,"Large", TRUE,"XL")Cleaner than 4 nested IFs.
Tips
- ✓End with TRUE, "default_value" as the catch-all — otherwise IFS returns #N/A for no match.
- ✓Order matters: the first TRUE condition wins.
- ✓Limit: 127 condition/value pairs.
Related Formulas
Nested IF
Nested IF formulas let you test multiple conditions and return different values ...
SWITCH
SWITCH picks a result from a list of pairs — cleaner and more readable than nest...
AND / OR / NOT
AND returns TRUE only if all arguments are TRUE. OR returns TRUE if any argument...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free