Skip to content
GridBelt
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign in
Start the free test
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign inCreate account
Start the free test
GridBelt

Practice Excel in your browser.

Excel Test

  • Level 1: Beginner
  • Level 2: Intermediate
  • Level 3: Expert
  • Excel test in 7 days
  • Leaderboard
  • Excel test for interview
  • Indeed Excel assessment

Practice

  • All exercises
  • Programs
  • For beginners

Guides

  • Excel formulas
  • Excel shortcuts

Company

  • About
  • Pricing
  • How we grade

© GridBelt. All rights reserved.

  • Privacy Policy
  • Terms of Use
  • Refund Policy

Excel is a trademark of Microsoft Corporation. Indeed, TestGorilla, SHL and other marks are the property of their owners. GridBelt is an independent practice site and is not affiliated with, endorsed by or sponsored by Microsoft, TestGorilla, SHL or Indeed.

  1. Practice
  2. /
  3. IF function

IF and ISBLANK practice: flag missing Tax IDs in 120 vendor rows

  • Intermediate
  • ~5 min
  • IF function

Accounts payable received the supplier master list from procurement: 120 vendors with category, contact email, Tax ID and payment terms. The system refuses to pay a supplier without a Tax ID, and the list has gaps in that column. Add a check column that reads Missing where the Tax ID is blank and OK everywhere else, so the team can filter the vendors to chase before the payment run.

What you need to do

  1. 1Click G2. The Tax ID for this vendor is in E2 — here it happens to be empty.
  2. 2Enter an IF formula whose test asks whether E2 is blank: ISBLANK(E2) returns TRUE for an empty cell, and so does E2="". Show "Missing" when the test is true and "OK" otherwise.
  3. 3Press Enter and fill G2 down to G121 (double-click the fill handle, or select G2:G121 and press Ctrl+D / ⌘D).
  4. 4Type a Tax ID into E2 and the flag must flip to OK; undo it (Ctrl+Z / ⌘Z) and click Check (Ctrl+Enter / ⌘+Return).

Answer cells

Feedback

Type your formula in the grid, press Enter, then Check. We grade the value in each answer cell and the formula behind it.

Tasks

  1. Not checkedIn G2, write an IF formula that shows "Missing" when the Tax ID in E2 is blank and "OK" otherwise — ISBLANK(E2) or E2="" both work — then fill it down to G121.

Desktop recommended for spreadsheet tasks. The sheet scrolls inside this box.

StartInsertFormulasDataView
A1fxPreparing your workbook…
A
B
C
D
E
F
G
H
I
J
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Sheet1

Enter your formula in the sheet, then check.

About this exercise

A 120-row dataset on one sheet, one answer cell, about 5 minutes. Graded in your browser: the value and the formula behind it, with feedback that names the fix.

How to solve it

  • G2=IF(ISBLANK(E2),"Missing","OK")

ISBLANK(E2) returns TRUE when the cell has nothing in it — no value, no formula — and FALSE for anything else, including a single space. Wrapped in IF, that TRUE/FALSE becomes the Missing / OK label. The test E2="" reaches the same result on this data because every gap here is a genuinely empty cell; filling the formula down checks all 120 vendors in one go.

Pitfall 1: ISBLANK and ="" disagree on two kinds of cells — a formula that returns "" (ISBLANK says FALSE, ="" says TRUE) and a cell containing only spaces (both say FALSE). Exports from ERP systems often pad empty fields with a space; =IF(TRIM(E2)="",…) or =IF(LEN(TRIM(E2))=0,…) catches those too. Pitfall 2: writing =IF(E2=" ",…) or =IF(E2=0,…) — a blank cell compares equal to 0 in Excel, but so does a Tax ID of 0, and the space-version only matches cells with exactly one space. Pitfall 3: ISBLANK(E2:E121) in a single cell does not count blanks; use COUNTBLANK(E2:E121) for the total, which is the next natural question after this flag column. Alternatives: COUNTBLANK(E2)=1 as the test; IF(E2<>"","OK","Missing") written from the non-blank side. Downstream: the flag column is what you filter on (Ctrl+Shift+L / ⌘+Shift+F) and what COUNTIF(G2:G121,"Missing") summarises for the status report.

Other ways that work

  • =IF(E2="","Missing","OK") — equality test instead of ISBLANK; also treats an empty-string result as blank
  • =IF(LEN(TRIM(E2))=0,"Missing","OK") — survives cells that contain only spaces
  • =IF(COUNTBLANK(E2)=1,"Missing","OK") — COUNTBLANK on a single cell returns 1 for a blank

Common mistakes

Testing E2=" " (a space between the quotes) or E2=0: the first never matches an empty cell, the second also matches real values, so the flags are wrong on some rows. Use ISBLANK(E2) or E2="" with nothing between the quotes.

How we grade

Any formula that produces the right result is accepted, unless the task names a function: then another function earns half credit. We compare values with a small tolerance and ignore case and spaces in text. A correct number typed by hand instead of a formula earns half credit. Multi-cell tasks earn full credit at 100% of cells, half credit from 50%. Where it matters, we also change an input cell on a copy of your sheet and check that your formula follows.

Answers computed with Excel 365 rules and checked in our grading engine on November 16, 2026. Author: GridBelt team.

In these programs

  • Excel for Administrative AssistantsDay 8
  • Excel for Accounting and BookkeepingDay 3
  • Learn Excel From ScratchDay 10

Related exercises

  • Pass or Fail with IFBeginner, ~4 min
  • Margin % without #DIV/0!Intermediate, ~6 min
  • Orders per status with COUNTIFBeginner, ~5 min

Function reference

Official documentation

Next exercise

Margin % without #DIV/0!