Excel Practice - IFS
Instruction
Grade A2: return "A" if at least 90, "B" if at least 80, otherwise "C".
Formula Syntax
=IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)
- logical_test1: Logical condition that evaluates to TRUE or FALSE.
- value_if_true1: Result returned when the condition is TRUE.
- [logical_test2: Logical condition that evaluates to TRUE or FALSE.
- value_if_true2]: Result returned when the condition is TRUE.
- ...: Additional optional arguments.
What it does
Evaluate multiple conditions without nesting IF repeatedly.
logical-checks.xlsx
| A | B | C | |
|---|---|---|---|
| 1 | Score | Attendance % | Approved |
| 2 | 92 | 96 | Yes |
| 3 | 78 | 88 | No |
| 4 | 85 | 91 | Yes |
| 5 | 66 | 84 | No |
| 6 | 90 | 93 | Yes |
| 7 | Output |
Input Formula
Need Help?
Tips
- Use IFS with clean and consistent ranges for predictable results.
- Validate data types (number, text, date) before applying the formula.
- Test the formula with a small sample first, then scale it to larger ranges.