IFS()
Checks multiple conditions in order and returns the value for the first one that's true — no nesting required.
IFS(logical_test1, value1, [logical_test2, value2], ...)IFS replaces a chain of nested IFs. It checks each condition in order and returns the value paired with the first TRUE one, skipping the rest.
If none of the conditions are true, IFS returns #N/A — add a final TRUE, "default value" pair to guarantee a fallback.
Arguments
- logical_test1
- The first condition to check.
- value1
- What to return if logical_test1 is TRUE.
- logical_test2, value2, ...optional
- Additional condition/value pairs, checked in order.
Examples
=IFS(B2>=90,"A", B2>=80,"B", B2>=70,"C", TRUE,"F")→B
Grades a score of 85 by checking thresholds top to bottom.