Excel IS functions (ISBLANK, ISNUMBER…) practice exercises
5 graded problems with realistic data, from easy to medium.
A small toolkit for checking a cell rather than calculating with it: is it empty, is it the right type, did the formula above it fail? 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 IS functions (ISBLANK, ISNUMBER…) guide first: syntax, a worked example and the mistakes people make.
In this set
- Flag a cell that's actually empty
- Check that an entry is actually a number
- Check that an entry is text, not a number
- Check whether a lookup actually found anything
- Count how many entries are still missing
The exercises
Before running totals on this data, check whether the quantity for row 2 was ever entered.
| A | B | C | |
|---|---|---|---|
| 1 | Item | Qty | |
| 2 | Widget | ? |
Enter a formula in C2.
Show a hint
ISBLANK(cell) returns TRUE only for a genuinely empty cell, not a cell containing 0 or "": =ISBLANK(B2).
A SUM or AVERAGE formula won't warn you about a missing entry. It just quietly treats it as 0. ISBLANK is how you check for a gap in the data before it skews a result.
A form field should contain a quantity, but someone typed "N/A" into C2 by mistake (column B just tracks status). Check whether C2 actually holds a number.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Field | Status | Qty | |
| 2 | Order #4471 | Open | N/A | ? |
Enter a formula in D2.
Show a hint
ISNUMBER(value) returns TRUE only for an actual number: =ISNUMBER(C2).
ISNUMBER is a quick data-quality gate; pair it with IF to catch bad entries before they break a calculation downstream.
A customer ID column should always contain a text code, stored in D2 here (column B just holds the region). Check whether D2 is actually text.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Row | Region | Customer ID | ||
| 2 | 1 | East | CUST-0092 | ? |
Enter a formula in E2.
Show a hint
ISTEXT(value) returns TRUE only for text: =ISTEXT(D2).
ISTEXT is ISNUMBER's mirror image: useful whenever a column is supposed to hold codes or names and you want to catch a stray number that snuck in.
You're looking up a product code that doesn't exist in the price table. Before showing the result to anyone, check whether the lookup came back as an error.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Code | Price | Lookup code | |
| 2 | A100 | 25 | Z999 | |
| 3 | A200 | 40 | ? | |
| 4 | A300 | 15 |
Enter a formula in D3.
Show a hint
Wrap the lookup in ISERROR: =ISERROR(VLOOKUP(D2,A2:B4,2)). It returns TRUE for any "#"-style error, including VLOOKUP's #N/A.
ISERROR is what IFERROR checks under the hood: useful on its own whenever you want to know THAT something failed without yet deciding what to show instead.
A survey has 6 responses expected in column B, but not everyone answered. Count how many are still blank.
| A | B | |
|---|---|---|
| 1 | Respondent | Answer |
| 2 | 1 | Yes |
| 3 | 2 | |
| 4 | 3 | No |
| 5 | 4 | |
| 6 | 5 | Yes |
| 7 | 6 | |
| 8 | Still missing | ? |
Enter a formula in B8.
Show a hint
COUNTBLANK(range) counts the empty cells in a range: =COUNTBLANK(B2:B7).
COUNTBLANK is the fastest way to see how complete a dataset actually is, before trusting any total or average computed from it.
Solve these in a real grid
Type your formula, get graded instantly. Your first 10 exercises are free, no signup.
Start the IS functions (ISBLANK, ISNUMBER…) exercises →