Nested IF Functions
Create complex conditions using nested IF statements.
Task:
You are assigning grades based on a complex grading scale with multiple cutoffs. Create grade categories in column C: A (90+), B (80-89), C (70-79), D (60-69), and F (<60) using nested IF functions to accurately reflect student performance.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of IF
0/4The same formula in the other shapes it takes at work.
- Nested IF Functions
Create complex conditions using nested IF statements.
CoreAdvanced - Nested IF returning numbers
Bands that return a price rather than a grade.
Intermediate - Nested IF: why the order of tests matters
Test the smallest band first and the bigger ones are never reached.
Advanced - Nested IF with AND in one branch
One band needs two conditions; the next needs only one.
Advanced
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Student | Score | Grade |
| 2 | John | 95 | |
| 3 | Mary | 87 | |
| 4 | Tom | 76 | |
| 5 | Sarah | 65 | |
| 6 | Mike | 58 |
What this exercise teachesMay contain the answer
Nested IF functions allow for complex multi-condition logic by embedding IF statements within each other, evaluating conditions sequentially.