Information

ISBLANK Function in Excel

Returns TRUE if the cell is empty.

Syntax

  • =ISBLANK(value)

Arguments

  • value (required): The cell to check

Examples

  • =ISBLANK(A1) - Check if A1 is empty - Result: TRUE or FALSE
  • =IF(ISBLANK(A1), "Empty", A1) - Handle empty cells - Result: Value or Empty

Excel ISBLANK function documentation

  • ISBLANK returns TRUE if a cell is empty; FALSE if it contains any value, formula, or zero.
  • Syntax: =ISBLANK(value). Often used inside [IF](/functions/if/) for data validation and QA.
  • Note: formula returning "" (empty text) is NOT blank — ISBLANK is FALSE for "".
  • Related: [COUNTBLANK](/functions/countblank/), [IF](/functions/if/), [ISNUMBER](/functions/isnumber/).

ISBLANK syntax and common traps

  • value: single cell reference — ISBLANK(A2).
  • Space character " " is not blank — use TRIM and LEN checks for whitespace-only cells.
  • ISBLANK on merged cell refers to top-left cell only.
  • Combine: =IF(ISBLANK(A2), "Missing", A2) for friendly forms.

Step-by-step: flag incomplete survey rows

  • Step 1 — Required field email in column C.
  • Step 2 — =IF(ISBLANK(C2), "Incomplete", "OK") in helper column.
  • Step 3 — Filter Incomplete before export.
  • Step 4 — For "" formulas use =IF(C2="", "Incomplete", "OK") instead.
  • Step 5 — Dashboard count: =COUNTBLANK(C2:C500) vs [COUNTA](/functions/counta/).

ISBLANK vs COUNTBLANK vs LEN

  • ISBLANK — test one cell in logic formulas.
  • COUNTBLANK — count empty cells in range.
  • LEN(TRIM(A2))=0 — detect whitespace-only cells ISBLANK misses.
  • Information category: [/categories/information/](/categories/information/).

Worked examples to copy

  • Simple test: =ISBLANK(A2).
  • Default value: =IF(ISBLANK(A2), 0, A2).
  • Block submit: =IF(ISBLANK(B2), "Enter name", "").
  • Row complete: =AND(NOT(ISBLANK(A2)), NOT(ISBLANK(B2))).

People also ask

  • ISBLANK on formula ""? — Returns FALSE; cell is not empty.
  • ISBLANK vs empty string? — ISBLANK only TRUE for truly empty cells.
  • ISBLANK on zero? — FALSE; zero is a value.
  • ISBLANK Google Sheets? — Similar; Sheets also has ISBLANK().

Common errors

  • Cells with formulas returning empty string are not blank
  • Spaces make cell not blank

Use cases

  • Data validation
  • Conditional formatting
  • Error handling

Frequently asked questions

  • Why does ISBLANK return FALSE for an empty-looking cell? The cell may contain: 1) A formula returning "", 2) Spaces or non-printing characters, 3) An apostrophe. Use =LEN(A1)=0 to check for truly empty content, or =ISBLANK(A1) only for cells with no content at all.
  • How do I count blank cells in a range? Use =COUNTBLANK(A1:A100) to count empty cells. For non-blank cells: =COUNTA(A1:A100). COUNTBLANK counts cells that are truly empty or contain formulas returning "".
  • How do I fill blank cells with a value? Select range, press F5 > Special > Blanks > OK. Type your value and press Ctrl+Enter to fill all selected blanks. Or use =IF(ISBLANK(A1), "N/A", A1) in a helper column.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.

When to use ISBLANK

  • Data validation — common Information scenario for ISBLANK.
  • Conditional formatting — common Information scenario for ISBLANK.
  • Error handling — common Information scenario for ISBLANK.

ISBLANK in the Information category

  • Browse all Information functions at /categories/information/ for related formulas.
  • ISBLANK syntax: =ISBLANK(value)
  • value (required): The cell to check
  • Confirm ISBLANK arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.

Formula checklist before you copy down

  • Confirm ISBLANK arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.
  • If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
  • Spot-check three known input rows manually against expected output.

Related Excel functions

  • ISNUMBER (/functions/isnumber/): Returns TRUE if the value is a number.
  • ISTEXT (/functions/istext/): Returns TRUE if the value is text.
  • ISERROR (/functions/iserror/): Returns TRUE if the value is any error value.

Errors to watch for

  • Cells with formulas returning empty string are not blank — review causes on linked error pages in the directory.
  • Spaces make cell not blank — review causes on linked error pages in the directory.

Copy-paste audit workflow

  • Enter ISBLANK on three test rows with known expected output documented on a QA tab.
  • Fill down only after absolute references are locked on lookup tables and rate tables.
  • Compare against manual calculation or a calculator for financial and statistical functions.
  • Search this directory for comparison guides when choosing between similar functions in the same category.

ISBLANK worked examples to copy

  • =ISBLANK(A1) — Check if A1 is empty. Expected result: TRUE or FALSE.
  • =IF(ISBLANK(A1), "Empty", A1) — Handle empty cells. Expected result: Value or Empty.

ISBLANK reference summary for crawlers and offline review

  • ISBLANK belongs to the Information category in Excel. Returns TRUE if the cell is empty.
  • Full syntax: =ISBLANK(value). Open /functions/isblank/ for parameters, FAQs, and related pages.
  • Common mistakes: Cells with formulas returning empty string are not blank; Spaces make cell not blank
  • Pair this function with comparison guides when another Excel formula might fit the same task better.
  • Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.