ISBLANK returns TRUE when a referenced single cell is completely empty and FALSE when that cell contains a value, including a lone space. It is for testing actual emptiness, not whether a cell looks empty on screen.

Syntax: =ISBLANK(cell) — a single required argument, in Apple’s current English Functions Help, edition 15.4. See Apple’s ISBLANK function reference (accessed 2026-10-11). There are no additional documented optional arguments or defaults for this function.

Use it to identify unentered mandatory data in intake sheets, inventory logs, or form-like tables. Unlike a text-equality test, ISBLANK is expressly about a cell reference. A faint-looking space is still content.

The important distinction is stored/evaluated value type, not the visible formatting alone. An imported value may look like a number or date while being held as text. Apple describes separate number, string, Boolean and date/time types in its value-type reference.

=ISBLANK(cell)

The placeholder cell is a descriptive argument name, not text to type literally. A working reference is B6, so a complete formula is =ISBLANK(B6). Write = to start a formula. The single argument has no comma of its own; nested functions with multiple arguments use commas in Apple’s English examples, or semicolons when your decimal separator is a comma according to Apple’s Functions overview. For example, =IF(ISBLANK(B6),"Yes","No") becomes =IF(ISBLANK(B6);"Yes";"No") in that locale.

A quick independent check

B2 is untouched → TRUE; B3 contains one space → FALSE; B6 contains numeric 42 → FALSE.

Create a table called Intake Types with a header row. Column A is a human-readable case label, column B is the value under test, and column C will contain the test formula. Create the cells deliberately—automatic input recognition can otherwise change their types.

Do not paste the B column from this Markdown table as plain text and assume Numbers will create the intended types. The date and Boolean examples are formulas, the text ID needs deliberate formatting, and B2 must remain empty. The outputs below are expected/documentation-derived, not screenshots or measurements of a live Numbers session.

Enter the formula and inspect the expected outcomes

In C2 enter =ISBLANK(B2) and copy through C9. A fully empty B2 returns TRUE. A space in B3 and the text-formatted ID in B4 both return FALSE. This is particularly useful when users accidentally tap the spacebar instead of completing a field.

Documented-type expected results for =ISBLANK(B2) copied through C9:

These outcomes were checked against an independent Python type-model using explicit values (blank, text, numeric, date, Boolean). That is not native Numbers execution. Automatic import/conversion and special formula-return types still require a real Numbers app validation pass.

Required-field status on an intake sheet

If a cell must be filled in, place =IF(ISBLANK(B2),"Missing","Entered") in a separate status column. With B2 truly empty, Missing is the documentation-based expected result; changing B2 to 42 changes it to Entered. This formula answers whether anything is entered, not whether the content is valid. Follow with a separate type check if amounts or dates are required.

A multi-cell trap that looks reasonable but is wrong

Leave B20 and B21 completely empty in a test table. Apple’s reference explicitly states that =ISBLANK(B20:B21) is FALSE, not TRUE. ISBLANK is a single-cell check. For a collection, apply the check one cell at a time or investigate the separate COUNTBLANK function and its own documented behavior; do not assume the two are interchangeable.

Empty display is not enough evidence

If the cell contains one regular space, ISBLANK returns FALSE even though it may appear blank. The same applies to nonprinting characters according to Apple. Use the formula bar and, for text troubleshooting, LEN to inspect suspicious entries; do not routinely TRIM meaningful identifiers without permission.

• It looks blank but returns FALSE: inspect for whitespace or nonprinting characters; Apple specifically documents these as nonblank.
• A range returned FALSE: only pass one cell reference. Apple documents FALSE for references to multiple cells even when all are empty.
• Formula result looks empty: a cell containing a formula is not the same as a never-populated cell. The exact formula-returns-empty-string case was not executed here; label it for native Numbers review instead of inventing a result.
• Different table: use a qualified reference such as Intake Types::B2, selecting the cell through the Formula Editor to avoid spelling errors.
• Need number of missing values: this Boolean check is not itself a counting function; consider a separately verified aggregation method.

For an initial diagnostic, try a simple function call using Apple’s examples before a complex nested expression. If a formula shows an error instead of a TRUE/FALSE result, investigate the source reference and formula syntax rather than treating the error as a Boolean FALSE. Apple has a separate error-review guide, also accessed 2026-10-11.

In the same table, use B6. Apple documents cross-table references such as Intake Types::B6 and cross-sheet references in the form Sheet 2::Intake Types::B6 when identification is needed. Selecting the cell in the Formula Editor is safer than manually guessing a qualified reference. Relative references move with copied formulas, while absolute references can be locked.

This guide follows the publicly accessible Apple Formulas and Functions Help 15.4 on 2026-10-11. The documentation also describes using the function browser in Numbers on Mac, iPhone and iPad and through iCloud.com; this does not independently establish the first Numbers app release or availability of every function on every historical platform. Native execution on Mac, iPhone/iPad and iCloud was not performed.

Excel and Google Sheets also document ISBLANK for empty-cell checks, but the behavior of formulas returning empty strings and imported whitespace should be validated in the target app. Do not transfer a Numbers multi-cell ISBLANK formula as if all apps had the same documented rules.

When transferring workbooks, test the actual input types, arguments, and output on the destination software; do not assume a successful import proves formula equivalence. For help on specific cross-app function families consult Microsoft’s IS functions and Google Sheets’ published function list.

Publication note: Related guide links should be checked in the generated site. Native Numbers execution is not recorded.

• Documentation inspection: https://support.apple.com/guide/functions/isblank-ffa57eb830/15.4/web/1.0, edition 15.4, read on 2026-10-11. The syntax, argument shape and function-level TRUE/FALSE rule come from that function page.
• Cell references and locales: Apple references and Functions overview, read 2026-10-11.
• Value types: Apple value types, read 2026-10-11.
• Independent calculation: a Python type-model computed the eight tabulated expected logical outcomes and asserted the row results. This is a separate model, not an observation from the Numbers engine.
• Coverage: This function was added after the earlier eight-page Numbers launch collection.

• Apple Numbers — function documentation
• value-type reference
• Apple’s Functions overview
• Apple references

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Apple Numbers.

• No genuine Apple Numbers screenshots are included; this guide does not use mock application images.