IFS
Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.
LogicalLogic & ConditionsModern Excel FunctionsMost Used
What it does
Checks multiple conditions and returns the first matching result (avoids nested IFs).
Syntax
IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)
Arguments
logical_test1(logical) — First condition to test.value_if_true1(value) — Returned when the first condition is TRUE.
Examples
Score bands
Return A/B/C based on Score.
FORMULA
=IFS(A2>=90,"A",A2>=80,"B",A2>=70,"C",TRUE,"D")
RESULT
B
SAMPLE DATA
| A | |
|---|---|
| 1 | Score |
| 2 | 85 |
| 3 | 95 |
| 4 | 72 |
| 5 | 60 |