Formula Library
IFS
logicalChecks multiple conditions and returns the value corresponding to the first true condition.
Syntax
=IFS(condition1, value1, condition2, value2, ...)Example
Excel
=IFS(A2>=90,"A",A2>=80,"B",A2>=70,"C",TRUE,"F")Returns a grade letter based on the score in A2, with TRUE as a catch-all default.
Tips & Notes
- →Use TRUE as the final condition for a default/else value
- →Cleaner than nested IF statements
- →Returns #N/A if no condition is true and no default is set
See Also
Need a custom IFS formula?
Describe exactly what you need and get the formula generated instantly.