Google Sheets IF Blank: Formulas, Examples, and Fixes

In Google Sheets, use =IF(A2="","Blank","Not blank") to test whether A2 is empty or returns an empty string; replace the results with whatever you want the formula to show. If you need to distinguish a truly unused cell from a formula that displays nothing, use =ISBLANK(A2) instead. These formulas assume the value you are checking is in A2.

What “blank” means in Google Sheets

A cell can look empty without being empty in the same way as a cell that has never been used. It might contain a formula whose result is an empty string, spaces, or a value hidden by formatting. Choosing the right test depends on what you want your spreadsheet to do with those cases.

Truly empty: The cell contains no value or formula. ISBLANK identifies this case.
Visually empty: The cell may contain a formula such as one that returns "". A comparison with an empty string, such as A2="", usually treats it as empty for an IF test.
Spaces only: A cell containing a space is not truly empty, even though the space can be hard to see. A basic blank test will not necessarily treat it as empty.
Zero: The number 0 is a value, not a blank. It should not be confused with an empty cell, even if number formatting makes the zero hard to notice.

This distinction matters in practical tasks such as deciding whether an order is ready, suppressing unfinished calculations, or counting missing responses. A formula that works for untouched cells may produce a different result when the cells contain formulas or imported whitespace.

Use IF to show a result when a cell is blank

IF checks a condition and returns one result when it is true and another when it is false. With the value to check in A2, this formula displays “Waiting” for an empty-looking cell and repeats the value otherwise: =IF(A2="","Waiting",A2). If A2 is empty, the result is Waiting; if A2 contains 27, the result is 27.

To leave the result cell visually blank until A2 has a value, use =IF(A2="","",A2*2). This assumes the input is in A2; if A2 is empty, the formula returns an empty string, and if A2 contains 27, it returns 54. The result cell still contains a formula, however, so it is not itself truly empty.

That last point is useful when building reports: a formula returning "" can keep a table tidy, but another formula that checks the result cell with ISBLANK will see the formula and return FALSE. Use an empty-string comparison when you mean “has no visible result,” and use ISBLANK when you mean “contains no value or formula.”

Choose between ISBLANK and an empty-string test

With A2 as the cell being checked, =ISBLANK(A2) returns TRUE only when A2 is genuinely empty. It returns FALSE if A2 contains a number, text, a space, or a formula—even a formula that displays nothing. This makes it useful for checking whether someone has entered anything into an input cell.

With the same A2 input, =IF(A2="","No entry","Entry found") treats a genuinely empty cell and a formula result of "" as no entry. It still treats a space as content. This is often the more practical choice for a report where the visible result matters more than how the cell was created.

For example, suppose A2 contains =IF(B2="","",B2). A2 appears empty when B2 is empty, but ISBLANK(A2) returns FALSE because A2 contains a formula. An empty-string comparison against A2 recognizes the displayed empty result. In short, don’t choose a test just by its name: decide whether you care about the cell’s contents or what it displays.

Handle cells that contain only spaces

Spaces commonly arrive through copied data, form exports, or manual entry. A cell containing one or more spaces is not blank, so A2="" is not a reliable way to flag it. If you want to treat ordinary leading and trailing spaces as blank, combine TRIM with LEN.

Assuming A2 holds the entry to inspect, =IF(LEN(TRIM(A2&""))=0,"Blank","Has content") returns Blank for an empty cell or a cell containing only spaces, and Has content for text or a number such as 0. The ampersand converts the value to text for the test; TRIM removes extra spaces at the ends and reduces repeated spaces between words. If internal spacing is meaningful, consider whether that cleanup matches your data rules before using it.

There are limits to this approach. Some imported text can contain nonbreaking spaces or other invisible characters that ordinary trimming may not remove. If a supposedly empty cell continues to fail the test, inspect the source or clean the imported data rather than assuming the cell is genuinely blank. Avoid deleting characters indiscriminately in data where spacing can carry meaning, such as codes or formatted identifiers.

Count blank cells in a range

When the goal is a count rather than a label, Google Sheets provides COUNTBLANK. If responses are in A2:A20, =COUNTBLANK(A2:A20) returns the number of blank cells in that range. It is useful for a quick completeness check, such as seeing how many survey answers are still missing.

COUNTBLANK also counts cells whose formulas return an empty string. That can be helpful when a formula-generated report should count cells that appear empty, but it differs from counting only cells that have never been used. If the distinction matters, use a test based on ISBLANK and count the TRUE results. With the cells to inspect in A2:A20, =SUM(ARRAYFORMULA(N(ISBLANK(A2:A20)))) counts only cells that are truly empty. This array formula returns 19 if all 19 cells in that range are empty.

Use the simplest method that matches the question. COUNTBLANK is easier to read when visually empty formula results should count as blank. The array formula is more precise when only untouched cells should count. Check a few cells manually if the total looks unexpected, especially in ranges populated by formulas.

Use IF with multiple cells

Sometimes a result should depend on more than one input. For example, a row might be ready only after both a name and an email address have been entered. Assuming the name is in A2 and the email address is in B2, =IF(AND(A2<>"",B2<>""),"Ready","Incomplete") displays Ready when neither cell is empty and Incomplete otherwise.

For the opposite rule—show a message if either required cell is missing—use OR. With the same A2 and B2 layout, =IF(OR(A2="",B2=""),"Please complete both fields","Ready") flags the row if at least one field is empty. These simple checks treat formula results of "" as empty, but not cells containing only spaces. If spaces are possible, clean or test the inputs accordingly.

When a row has many required fields, the formula can become long. A practical alternative is to use a helper column that checks each field or to make the input rules clearer with data validation. That can make it easier for another person to understand why a row is marked incomplete, rather than leaving them to decode a complicated formula.

Highlight blank cells with conditional formatting

Conditional formatting changes a cell’s appearance when a condition is met; it does not write a value into the cell. In Google Sheets in a web browser, select the range, choose Format > Conditional formatting, and set a rule. For a simple blank-cell highlight, choose the option to format cells if they are empty. To use a custom formula instead, select “Custom formula is” and enter =ISBLANK(A2) when the selected range begins at A2.

For example, if the apply-to range is A2:A100, the reference A2 in the custom formula should point to the first cell in that range. Sheets adjusts the reference for the other rows. Set a fill color and select Done. This rule highlights truly empty cells; it will not highlight cells with formulas that return an empty string.

If the goal is to highlight cells that look empty, use a custom formula based on an empty-string comparison, such as =A2="", for a range beginning at A2. To include cells with ordinary spaces, a custom rule can instead test the trimmed text: =LEN(TRIM(A2&""))=0. Keep the row and column references aligned with the first cell of the selected range so the rule evaluates each cell as intended.

Common problems and troubleshooting

The formula says a blank cell is not blank: Check whether it contains a formula, a space, or invisible imported text. Use the test that matches your goal, and inspect the formula bar for cell contents.
A zero is treated as blank: Confirm the formula is testing for an empty string rather than using a condition that treats zero as FALSE. Zero is a legitimate value and should be tested explicitly if it has special meaning.
The formula appears as text: Check whether the cell is formatted as plain text or whether an apostrophe was entered before the equals sign. Change the cell format if needed, then re-enter or edit the formula.
The result is unexpected after copying: Check the cell references. Relative references change when copied; use dollar signs, such as $A$2, when a reference should stay fixed.
The formula separator causes an error: The examples here use commas. A spreadsheet’s locale can require semicolons between formula arguments; check the locale settings or use the separator accepted by that sheet.

Also distinguish a formula error from a blank result. If a calculation is failing, an IF blank check may not address the underlying issue. Find out whether the source cell is empty, contains an error, or contains text that cannot be used in the calculation before changing the formula’s logic.

Frequently Asked Questions

What is the Google Sheets formula for if a cell is blank?
Assuming the cell to check is A2, use =IF(A2="","Blank","Not blank"). Replace the two text results with the output you need. It treats a formula result of an empty string as blank, but not a cell containing spaces.

Does ISBLANK work if a formula returns nothing?
No. If A2 contains a formula that returns "", ISBLANK(A2) returns FALSE because the cell contains a formula. Use an empty-string comparison when you want to test whether the formula’s displayed result is empty.

How do I count blank cells in Google Sheets?
For a range such as A2:A20, use =COUNTBLANK(A2:A20). It counts genuinely empty cells and cells whose formulas return an empty string, so check whether that behavior matches what you mean by blank.

How do I make a formula cell look blank?
With the input in A2, use =IF(A2="","",your_calculation), replacing your_calculation with a valid expression. The result displays nothing while A2 is empty, although the cell still contains the formula.

Are these formulas the same in Excel?
The basic functions IF, ISBLANK, and COUNTBLANK are also available in Excel, though separators can depend on locale. The steps above for conditional formatting describe Google Sheets in a web browser; Excel has a different interface for creating those rules.

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.