Practice by topic / Excel / Conditional Logic
IF-style formulas let a spreadsheet make decisions — pass or fail, on time or late, which rate applies — so you don't have to check each row by hand. These 10 exercises build up step by step, starting with assign a letter grade, classify shipping speed by cost, categorize age groups.
3 of 10 free · no sign-up needed · graded on the formula you write
A2 holds a numeric score. Write a formula in B2 that returns 'A' for 90+, 'B' for 80-89, 'C' for 70-79, and 'F' otherwise, using nested IF.
| A | B | |
|---|---|---|
| 1 | ||
| 2 | 84 | ? |
Nest each check inside the false branch of the previous one: =IF(A2>=90,"A",IF(A2>=80,"B",IF(A2>=70,"C","F")))
Nice — nesting IFs lets you check thresholds in order, falling through to the next check only when the current one fails.
Expected result in B2: B
A2 holds a shipping cost. Write a formula in B2 that returns 'Free' for 0, 'Standard' for under 15, and 'Express' for 15 or more, using nested IF.
| A | B | |
|---|---|---|
| 1 | ||
| 2 | 20 | ? |
Handle the zero case first, then nest for the rest: =IF(A2=0,"Free",IF(A2<15,"Standard","Express"))
Good — the first IF handles the special case (0), and the nested IF splits the remaining range.
Expected result in B2: Express
A2 holds a person's age. Write a formula in B2 that returns 'Child' under 13, 'Teen' under 20, and 'Adult' otherwise, using nested IF.
| A | B | |
|---|---|---|
| 1 | ||
| 2 | 16 | ? |
Nest the second check inside the first's false branch: =IF(A2<13,"Child",IF(A2<20,"Teen","Adult"))
Right — nested IF lets you carve a number line into three labeled zones.
Expected result in B2: Teen
A2 holds an order total. Write a formula in B2 that returns 20 for orders 500+, 10 for orders 200+, and 0 otherwise (percent discount), using nested IF.
| A | B | |
|---|---|---|
| 1 | ||
| 2 | 300 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A2 holds a risk score. Write a formula in B2 that returns 'High' for 80+, 'Medium' for 50+, and 'Low' otherwise, using nested IF.
| A | B | |
|---|---|---|
| 1 | ||
| 2 | 65 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A2 holds a numeric value. Write a formula in B2 that returns 'Low' under 18.5, 'Normal' under 25, and 'High' otherwise, using nested IF.
| A | B | |
|---|---|---|
| 1 | ||
| 2 | 22 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A2 holds days overdue. Write a formula in B2 that returns 0 for 0 days, 5 for 1-7 days, and 15 for more than 7 days, using nested IF.
| A | B | |
|---|---|---|
| 1 | ||
| 2 | 10 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A2 holds a score. Write a formula in B2 that returns 'Distinction' for 95+, 'Pass' for 50+, and 'Fail' otherwise, using nested IF.
| A | B | |
|---|---|---|
| 1 | ||
| 2 | 97 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A2 holds a distance in miles. Write a formula in B2 that returns 5 for under 50 miles, 12 for under 200 miles, and 25 otherwise, using nested IF.
| A | B | |
|---|---|---|
| 1 | ||
| 2 | 120 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A2 holds a customer's lifetime spend. Write a formula in B2 that returns 'VIP' for 5000+, 'Regular' for 500+, and 'New' otherwise, using nested IF.
| A | B | |
|---|---|---|
| 1 | ||
| 2 | 700 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →