Excel practice · Data Tools

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

  1. Flag a cell that's actually empty
  2. Check that an entry is actually a number
  3. Check that an entry is text, not a number
  4. Check whether a lookup actually found anything
  5. Count how many entries are still missing

The exercises

1. Flag a cell that's actually empty Easy

Before running totals on this data, check whether the quantity for row 2 was ever entered.

ABC
1ItemQty
2Widget?

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.

2. Check that an entry is actually a number Easy

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.

ABCD
1FieldStatusQty
2Order #4471OpenN/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.

3. Check that an entry is text, not a number Easy

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.

ABCDE
1RowRegionCustomer ID
21EastCUST-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.

4. Check whether a lookup actually found anything Medium

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.

ABCD
1CodePriceLookup code
2A10025Z999
3A20040?
4A30015

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.

5. Count how many entries are still missing Medium

A survey has 6 responses expected in column B, but not everyone answered. Count how many are still blank.

AB
1RespondentAnswer
21Yes
32
43No
54
65Yes
76
8Still 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 →

More data tools practice

All Excel practice exercises · Excel test prep