IF practice exercises
5 graded problems with realistic data, all medium.
Tests a condition and returns one value when it's true, another when it's false. The 5 exercises below come from LearnExcel's practice library. Each one gives you a realistic table, a cell to fill, and a hint if you get stuck. Read them here, then solve them in the interactive grid, where your formula is checked the moment you press Enter.
New to the function? Read the IF guide first: syntax, a worked example and the mistakes people make.
In this set
- Flag who passed the midterm
- Flag low inventory
- Flag the attendance bonus
- Flag bulk orders
- Decide indoor or outdoor
The exercises
Camille needs 60 or higher to pass. Write a formula that returns "Pass" or "Fail" based on her score.
| A | B | C | |
|---|---|---|---|
| 1 | Student | Score | Result |
| 2 | Camille | 54 | ? |
Enter a formula in C2.
Show a hint
IF(condition, value_if_true, value_if_false). Compare B2 to 60: =IF(B2>=60,"Pass","Fail").
IF is how spreadsheets make decisions: pass/fail, in-stock/out-of-stock, on-time/late.
The bookstore reorders any title with fewer than 5 copies left. Flag whether 'Intro to Statistics' needs a reorder.
| A | B | C | |
|---|---|---|---|
| 1 | Title | Copies Left | Status |
| 2 | Intro to Statistics | 3 | ? |
Enter a formula in C2.
Show a hint
=IF(B2<5,"Reorder","OK").
Reorder flags are IF applied to inventory: one threshold, one automatic decision.
Students with 90% attendance or higher earn a participation bonus. Check whether Tomas qualifies.
| A | B | C | |
|---|---|---|---|
| 1 | Student | Attendance % | Bonus |
| 2 | Tomas | 92 | ? |
Enter a formula in C2.
Show a hint
=IF(B2>=90,"Bonus","No Bonus").
Threshold-based bonuses, discounts, and eligibility checks are all the same IF pattern underneath.
Orders of 10 units or more qualify for the bulk rate. Check this order.
| A | B | C | |
|---|---|---|---|
| 1 | Order | Quantity | Rate |
| 2 | #4471 | 6 | ? |
Enter a formula in C2.
Show a hint
=IF(B2>=10,"Bulk","Standard").
Pricing tiers in real order systems are usually just an IF (or a chain of them) on quantity.
The club picnic moves indoors if the forecast high is below 60°F. Check today's plan.
| A | B | C | |
|---|---|---|---|
| 1 | Day | Forecast High | Venue |
| 2 | Saturday | 54 | ? |
Enter a formula in C2.
Show a hint
=IF(B2>=60,"Outdoor","Indoor").
A simple threshold check like this is how a lot of "what do we do today" logic ends up in a spreadsheet.
Solve these in a real grid
Type your formula, get graded instantly. Your first 10 exercises are free, no signup.
Start the IF exercises →