In Excel, use =ISBLANK(A2) to test whether cell A2 is genuinely empty; it returns TRUE if the cell has no content and FALSE if it contains a value, text, a space, or a formula. For example, if A2 is empty, the formula returns TRUE. The key detail is that a cell that looks blank is not always empty to Excel.
What the ISBLANK function checks
ISBLANK is a logical function: its result is either TRUE or FALSE. Its argument is a cell reference or another reference Excel can evaluate. It answers a narrow question—does this cell have nothing entered in it?—rather than asking whether the cell appears empty on the screen.
That distinction makes ISBLANK useful in data-entry checks, reports, and formulas that should behave differently when a field has not been filled in. It does not remove content, inspect formatting, or decide whether a value is meaningful. It simply checks whether the referenced cell is empty in Excel’s sense.
With A2 truly empty, the formula =ISBLANK(A2) returns TRUE. With the text Paid entered in A2, the same formula returns FALSE. A number such as 0, a date, an error value, or a formula in A2 also makes ISBLANK return FALSE.
A basic ISBLANK example
Suppose a worksheet tracks requests, and column A contains the requester’s name. You want a result in B2 that says whether the name is missing. First, leave A2 empty, then enter the following formula in B2:
With the requester name in A2 and the test formula in B2, =ISBLANK(A2) returns TRUE when A2 is empty and FALSE when A2 contains a name.
To display words instead of TRUE or FALSE, wrap the test in IF. With the requester name in A2 and this formula in B2, =IF(ISBLANK(A2),"Name missing","Name entered") displays Name missing when A2 is genuinely empty. If A2 contains a name, it displays Name entered.
In Microsoft 365 for Windows, type the formula directly into the result cell and press Enter. If you need the same check down a list, copy or fill the formula down: the relative reference A2 adjusts to A3, A4, and so on. On Mac, the formula works the same way; the interface and some keyboard shortcuts differ, but the function itself does not.
What Excel considers blank
A cell is genuinely blank when it contains no value, text, formula, or other cell content. A cell can still look blank while containing something that causes ISBLANK to return FALSE. Common examples include:
- A formula that returns an empty text string, often written as two quotation marks.
- One or more spaces, including a space entered accidentally.
- A zero displayed as blank because of a custom number format or a worksheet setting.
- Content hidden by formatting, a white font, or a column that is too narrow to show the value.
For example, a formula can make A2 appear empty without leaving it truly empty. With the formula entered in A2, ="" displays an empty-looking result. If B2 refers to A2, =ISBLANK(A2) returns FALSE because A2 contains a formula. The same is true if A2 contains a single space: there is content, even though it may be difficult to see.
Formatting alone does not make a cell blank. Clearing a cell’s number format may change how its contents look, but it does not remove a value or formula. To check what is behind a seemingly empty cell, select it and look at the formula bar. If a formula or characters appear there, ISBLANK will not treat the cell as empty.
Use ISBLANK with IF and other formulas
A common use is to keep a result cell empty until an input has been supplied. With a quantity in A2, put this formula in B2: =IF(ISBLANK(A2),"",A2*2). If A2 is truly empty, B2 displays nothing; if A2 contains 5, B2 displays 10. This prevents an unfinished row from displaying a calculation prematurely.
Remember that the empty-looking result in B2 is still a formula. If another formula tests B2 with ISBLANK, it returns FALSE. This is a frequent source of confusion in chained formulas: a cell can display nothing while still containing a formula that produces an empty string.
Sometimes the desired test is not “is this cell physically empty?” but “does this cell have a usable value?” For a field that may contain only ordinary spaces, a text-length test can help. With a comment in A2, =LEN(TRIM(A2))=0 returns TRUE if A2 is empty or contains only regular spaces, and FALSE if it contains text after those spaces are removed. TRIM does not remove every possible whitespace character, such as some nonbreaking spaces, so this is not a universal cleanup test.
Choose the test that matches the rule. Use ISBLANK when an empty cell specifically matters. Use a comparison with an empty string when a formula returning an empty string should count as empty too. Use a cleanup step when users may enter stray spaces and those should be ignored.
Highlight empty cells with conditional formatting
ISBLANK can also identify empty cells visually. To highlight genuinely empty cells in A2:A20 in Excel for Microsoft 365 on Windows:
- Select A2:A20.
- Choose Home > Conditional Formatting > New Rule.
- Choose Use a formula to determine which cells to format.
- Enter the formula
=ISBLANK(A2), choose Format to select a fill or other style, and confirm the rule.
The reference A2 is relative, so Excel adjusts it for each cell in the selected range. The formula returns TRUE for a genuinely empty cell and the formatting is applied. A formula that returns an empty string will not be highlighted by this ISBLANK rule, even if it looks empty. If that is not the behavior you want, use a rule based on the empty-string comparison instead.
On Mac, Conditional Formatting is also available from the Home tab, though the dialog layout can differ by Excel release. Excel for the web supports conditional formatting, but its available rule-editing controls may not match the desktop dialogs exactly.
ISBLANK compared with COUNTBLANK and COUNTA
ISBLANK checks one cell reference and returns TRUE or FALSE. COUNTBLANK counts blank cells in a range, while COUNTA counts cells that contain data. Those functions address related but different questions, so choosing the right one matters.
For example, suppose A2 is genuinely empty, A3 contains a formula that returns an empty string, A4 contains one space, A5 contains 0, and A6 contains the word Done. With those entries in A2:A6, =COUNTBLANK(A2:A6) returns 2: it counts the empty cell and the formula result that is an empty string. It does not count the space, zero, or text as blank.
With the same A2:A6 layout, =COUNTA(A2:A6) returns 4. COUNTA counts the formula in A3 as content, even though its displayed result looks empty, and counts the space, zero, and Done. This is why the counts from COUNTBLANK and COUNTA may not behave like a simple visual tally of empty-looking cells.
Use ISBLANK when a formula needs to branch based on one particular cell. Use COUNTBLANK when you need a count of blank cells in a range. Use COUNTA when you need to count cells with entries, while remembering that formulas returning empty text still count as entries.
Common problems and how to fix them
If ISBLANK returns FALSE for a cell that looks empty, check for a formula, spaces, or hidden content. Select the cell and inspect the formula bar. You can also press Delete to clear selected cell contents, but first make sure the cell does not contain information or a formula you need. Changing the font color or number format only changes appearance; it does not remove the underlying content.
If a copied formula gives an unexpected answer, verify the cell reference. A formula copied down should usually refer to the corresponding row. For example, a formula intended to test A3 may still test A2 if the reference was made absolute or the formula was copied in an unexpected way. In Excel, a dollar sign in a reference such as $A$2 locks that reference when copying.
If your data came from a website or another system, invisible characters can be harder to detect. TRIM removes ordinary leading, trailing, and repeated spaces, but it may not remove nonbreaking spaces or other imported characters. A useful first step is to inspect or clean the source data rather than assume that a visually empty cell is truly empty. Do not overwrite original data until you have checked what the cleanup changes.
Frequently Asked Questions
Does ISBLANK return TRUE for a formula that displays nothing?
No. A cell containing a formula is not genuinely empty, even when that formula returns an empty string. ISBLANK returns FALSE for that cell.
Does ISBLANK treat zero as blank?
No. A cell containing 0 is not blank, so ISBLANK returns FALSE. If formatting hides zero, the displayed appearance does not change the function’s result.
How do I test whether a cell is blank in Excel?
Use ISBLANK with the cell reference, such as =ISBLANK(A2). With A2 empty it returns TRUE; with content or a formula in A2 it returns FALSE.
Can ISBLANK check a whole range at once?
ISBLANK tests a referenced value rather than returning a simple count of all blank cells in a range. To count blank cells in a range such as A2:A20, use COUNTBLANK instead.
Why does ISBLANK return FALSE when the cell looks empty?
The cell may contain a formula returning an empty string, a space, or content hidden by formatting. Select it and inspect the formula bar; clear the content only if it is safe to do so.
Related
- Excel Name Manager Spill Range: Create and Use One
- Excel Edit Defined Name Range: Steps and Common Fixes
- Excel Trendlines: How to Add, Format, and Choose One
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel INDEX MATCH With Table Structured ReferencesYes—Excel INDEX MATCH works with table structured references. For example, if a table named Inventory has columns Item…
- Excel Formula for Date Range: Count Dates and MatchFor dates in A2:A100 and a start date in D2 and end date in E2, count dates in…
- Excel Formula to Password Protect a Sheet? What WorksNo Excel formula can password-protect a worksheet: formulas calculate values, but they cannot set sheet permissions or require…
- IF Function in Excel: Examples and Practical UsesIn Excel, the IF function checks whether a condition is true and returns one result if it is,…
- Excel SUM Ignore Errors: Formulas for Clean TotalsYes. To sum numbers while treating error cells as zero in Microsoft Excel for Microsoft 365, use =SUM(IFERROR(B2:B6,0));…
- SUMIF Excel Cell Reference: Syntax, Examples, and FixesWith criteria in A2:A6 and amounts in C2:C6, enter =SUMIF(A2:A6,"North",C2:C6) to add the amounts for rows marked North;…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.