Excel Practice - IF nested
Instruction
Build a nested IF formula to grade scores into A/B/C.
Formula Syntax
=IF(logical_test, value_if_true, IF(logical_test2, value_if_true2, value_if_false))
- logical_test: Logical condition that evaluates to TRUE or FALSE.
- value_if_true: Result returned when the condition is TRUE.
- IF(logical_test2: Logical condition that evaluates to TRUE or FALSE.
- value_if_true2: Result returned when the condition is TRUE.
- value_if_false): Result returned when the condition is FALSE.
What it does
Build a nested IF formula to grade scores into A/B/C.
exam-scores.xlsx
| A | B | |
|---|---|---|
| 1 | Student | Score |
| 2 | Rin | 92 |
| 3 | Sky | 81 |
| 4 | Tom | 74 |
| 5 | Uma | 88 |
| 6 | Val | 69 |
| 7 | Output |
Input Formula
Need Help?
Tips
- Use IF.NESTED 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.