Excel practice · Basics

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

  1. Flag who passed the midterm
  2. Flag low inventory
  3. Flag the attendance bonus
  4. Flag bulk orders
  5. Decide indoor or outdoor

The exercises

1. Flag who passed the midterm Medium

Camille needs 60 or higher to pass. Write a formula that returns "Pass" or "Fail" based on her score.

ABC
1StudentScoreResult
2Camille54?

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.

2. Flag low inventory Medium

The bookstore reorders any title with fewer than 5 copies left. Flag whether 'Intro to Statistics' needs a reorder.

ABC
1TitleCopies LeftStatus
2Intro to Statistics3?

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.

3. Flag the attendance bonus Medium

Students with 90% attendance or higher earn a participation bonus. Check whether Tomas qualifies.

ABC
1StudentAttendance %Bonus
2Tomas92?

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.

4. Flag bulk orders Medium

Orders of 10 units or more qualify for the bulk rate. Check this order.

ABC
1OrderQuantityRate
2#44716?

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.

5. Decide indoor or outdoor Medium

The club picnic moves indoors if the forecast high is below 60°F. Check today's plan.

ABC
1DayForecast HighVenue
2Saturday54?

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 →

More basics practice

All Excel practice exercises · Excel test prep