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.