Google Sheets IF ISBLANK: Check for Empty Cells

In Google Sheets, use IF with ISBLANK to return one result when a cell is truly empty and another when it contains something. For example, with the cell to check in A2, enter =IF(ISBLANK(A2),"Blank","Not blank"); the result is “Blank” only when A2 has no content.

What ISBLANK checks in Google Sheets

ISBLANK tests whether a referenced cell is empty. It returns the Boolean value TRUE for a genuinely empty cell and FALSE if the cell contains a value, text, a space, or a formula. The function does not decide whether a value is useful or whether it merely looks empty; it checks whether anything is in the cell.

That distinction matters because a blank-looking cell is not necessarily empty. A formula can return an empty text string, and a cell can contain a space that is difficult to see. In either case, ISBLANK returns FALSE. Conversely, a cell displaying the number 0 is not blank: zero is a value, even if a spreadsheet’s formatting makes it less noticeable.

The function takes one cell reference as its argument. It can be used by itself, but combining it with IF makes the test useful in a report, checklist, or data-entry sheet: IF chooses what to display based on whether ISBLANK returns TRUE or FALSE.

Basic IF and ISBLANK formula

The general structure is IF(ISBLANK(cell), value_if_empty, value_if_not_empty). The first argument tests the cell; the next two specify what the formula should return for TRUE and FALSE. The results can be text in quotation marks, numbers, or other formulas.

With a status formula in B2 and the input cell in A2, use:

=IF(ISBLANK(A2),"Enter a value","Ready")

If A2 is empty, B2 displays “Enter a value.” If A2 contains a name, date, number, or formula, B2 displays “Ready.” The formula checks A2, not B2, so placing it in B2 does not make the test circular.

To apply the same logic to more rows, put the formula in B2 and fill it down. Each copied formula adjusts its reference, so the next row checks A3, then A4, and so on. In Google Sheets, you can drag the small blue fill handle at the lower-right corner of the selected cell down the column. Make sure the reference changes as intended before relying on the results.

ISBLANK versus checking for an empty string

ISBLANK is the right choice when the question is “Does this cell contain anything at all?” Sometimes, though, a spreadsheet should treat a formula that displays nothing as empty. In that case, a comparison with an empty string can be more suitable.

With the cell to evaluate in A2, this formula treats a genuinely empty cell and a cell containing a formula that returns an empty string as blank:

=IF(A2="","Blank or empty text","Contains a value")

The comparison is not identical to ISBLANK. For example, if A2 contains =IF(C2="","",C2), the cell displays nothing, but ISBLANK(A2) is FALSE because A2 contains a formula. The comparison A2="" is TRUE in that situation, so the IF formula above returns “Blank or empty text.” It also treats a genuinely empty A2 as an empty string for this comparison.

Neither test automatically treats a space as empty. If A2 contains one or more spaces, it has text in it. Decide what “blank” should mean for your task before choosing the test: physically empty, visually empty, or empty after ignoring certain whitespace are different conditions.

Count blank cells in a range

If the goal is to count missing entries rather than label one cell, use COUNTBLANK. It is designed to count blank cells in a range and also counts formulas that return empty text. That makes it useful for checking a form or a list where some cells may contain formulas.

With entries expected in A2 through A10, use:

=COUNTBLANK(A2:A10)

If A2:A10 contains six genuinely empty cells, one cell with a formula returning an empty string, and three cells with values, the result is 7. The formula counts the empty-string result as blank, unlike ISBLANK. A cell containing a space is not counted as blank.

For a row-by-row status, IF and ISBLANK are more informative. For a total number of missing or empty-text entries, COUNTBLANK is simpler. These formulas answer different questions, so a count from COUNTBLANK may not match the number of TRUE results from a separate ISBLANK test.

Choose the right test for your data

Pick the condition based on how your sheet is built and what downstream users need. A strict empty-cell test can prevent a formula-filled cell from being mistaken for an unused input. A broader empty-text test can be more helpful when formulas deliberately hide results until other data is entered.

Use ISBLANK when only cells with no content should count as empty, such as checking whether a person has entered a value in a designated input cell.
Use a comparison with an empty string when both truly empty cells and formulas returning "" should be treated as empty.
Use COUNTBLANK when you need a count across a range and want empty-string formula results included.
Use TRIM with LEN when ordinary leading or trailing spaces should be ignored as well as an empty cell. Check for unusual whitespace separately if data is copied from websites or other systems.

For example, if users type names into a column, a space-only entry should generally not pass as a completed name. With the text to check in A2, this test returns TRUE when A2 is empty or contains only ordinary spaces:

=LEN(TRIM(A2))=0

TRIM removes leading, trailing, and repeated ordinary spaces from text; LEN then counts the remaining characters. This is a different rule from ISBLANK and may not catch every special whitespace character found in imported text. Use it only if ignoring ordinary spaces matches the purpose of the sheet.

Use ISBLANK to flag missing inputs

A practical use is to show a reminder beside required fields. For example, a registration sheet might have names in A2:A100 and a status column in B. Put the IF-and-ISBLANK formula in B2, then fill it down. A reminder appears only for truly empty name cells; cells containing a formula that returns an empty string will be treated as occupied. If those formula cells should also trigger a reminder, use the empty-string comparison instead.

You can also highlight empty input cells with conditional formatting instead of adding a status column. In Google Sheets in a web browser, select the range to check, then choose Format > Conditional formatting. Under “Format cells if,” choose “Custom formula is” and enter an ISBLANK formula for the top-left cell of the selected range. For a range A2:A100, use:

=ISBLANK(A2)

Choose a formatting style and select Done. The reference should correspond to the first cell in the selected range so the rule can adjust for each row. Conditional formatting changes how qualifying cells look; it does not insert text or make a cell required. The menu names and behavior described here are for Google Sheets, not Excel.

Common problems and how to fix them

A cell looks empty but ISBLANK returns FALSE. Check whether it contains a formula, a space, or another invisible character. Select the cell and look at the formula bar to see whether a formula or text is present. A formula returning "" still occupies the cell for ISBLANK purposes.

A zero is being treated as not blank. That is expected. Zero is a value, not an empty cell. If zero should count as “no response” in your particular workflow, test for zero explicitly rather than describing it as blank. Be careful: a comparison that treats zero as missing can hide legitimate numeric results.

The formula shows an error or unexpected text. Confirm that the reference points to the intended input cell, and check that each text result is enclosed in straight double quotation marks. When copying a formula down, look for shifted references. Google Sheets normally adjusts relative references as you fill formulas into adjacent cells.

Whitespace survives a cleanup test. TRIM handles ordinary spaces but is not a universal cleaner for every character that can appear in imported data. Text copied from a web page may include non-breaking spaces or other characters. If a value remains after using TRIM, inspect or clean the source data rather than assuming ISBLANK is malfunctioning.

A conditional-format rule highlights the wrong cells. Check the selected range and the reference in the custom formula. The formula should be written relative to the range’s top-left cell; an incorrect row or a fixed reference can make the rule evaluate a different cell than intended.

Frequently Asked Questions

Does ISBLANK treat a formula returning an empty string as blank?

No. A formula is present in the cell, so ISBLANK returns FALSE even if the formula displays nothing. Use a comparison such as A2="" if the formula’s empty-text result should count as blank.

Does ISBLANK consider zero a blank cell?

No. Zero is a number, so ISBLANK returns FALSE. If zero has a special meaning in your data, create a separate test for zero rather than relying on a blank-cell test.

Can ISBLANK check a whole range at once?

ISBLANK is used to test a cell reference. For a total of blank cells across a range, use COUNTBLANK, such as =COUNTBLANK(A2:A10). For individual results, apply an ISBLANK formula to each row.

Why does a cell with spaces fail the blank test?

Spaces are text characters, so the cell is not empty. If ordinary spaces should be ignored, use a cleanup test such as =LEN(TRIM(A2))=0, while remembering that unusual whitespace may need separate handling.

Is the Google Sheets formula different in Excel?

The basic IF and ISBLANK functions also exist in Excel, but this article’s menu path for conditional formatting is for Google Sheets in a browser. Excel uses its own ribbon and conditional-formatting menus, so follow instructions for the Excel version you are using.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.