IFS Function in Excel
Intermediate
Checks multiple conditions and returns a value corresponding to the first TRUE condition.
Syntax
=IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)Example
Use Case
Assign letter grades based on score ranges (A, B, C, D, F).
Common Errors to Avoid
- #N/A error if no conditions are TRUE (no default value)
- Not available in Excel 2016 or earlier
- Evaluates in order - put most specific conditions first
Pro Tips
Much cleaner than nested IF statements. Always include a final TRUE condition as catch-all: =IFS(A1>90,'A', A1>80,'B', TRUE,'F'). Order matters - put most restrictive conditions first. Maximum 127 condition pairs.
Need help with this formula?
Our AI Formula Generator can write this for you instantly.
Try AI Formula Generator →