IF Cell Is Blank in Excel and Google Sheets
Purpose
Checking whether a cell is blank is one of the most fundamental IF patterns in any spreadsheet. Showing a Pending…
Checking whether a cell is blank is one of the most fundamental IF patterns in any spreadsheet. Showing a Pending label for rows where the status has not been filled in yet. Returning zero in a calculation column when the input is missing so downstream totals do not break. Flagging rows that need attention because a required field is empty. All of these are the same single question — is this cell blank? — answered by the same formula pattern. I use two interchangeable approaches: IF(ISBLANK(A2),...) which is the most readable version and explicitly communicates intent, and IF(A2="",...) which is slightly shorter and also catches cells containing formulas that return empty strings. Knowing both and understanding the difference between them prevents a class of subtle bugs that catch people out every time. This pattern combines naturally with AND and OR to create multi-condition blank checks that power most data-quality dashboards I build.
Syntax
✓ Excel 2003+
✓ Google Sheets
= Same syntax
=IF(ISBLANK(A2), value_if_blank, value_if_not_blank)
Alternative: =IF(A2="", value_if_blank, value_if_not_blank)
Arguments
| Argument | Required | Description |
|---|---|---|
| logical_test | Required | The blank check: ISBLANK(A2) or A2="". Both evaluate to TRUE when the cell is empty. ISBLANK is more readable; A2="" also matches formula-returned empty strings. |
| value_if_true | Required | What to return when the cell is blank — a message like Pending, a zero for numeric contexts, or an empty string to leave the cell visually blank. |
| value_if_false | Required | What to return when the cell has content — usually the cell value itself like A2, a label like Complete, or any calculation. |
How it works
ISBLANK evaluates the cell and returns TRUE when it is completely empty — no content, no formula, nothing — and FALSE when it has any value including text, numbers, dates, or a formula result. IF uses that TRUE or FALSE to choose which output to return. The alternative A2="" compares the cell to an empty string and returns TRUE for both genuinely empty cells and cells containing a formula that evaluates to "". This distinction matters: a cell with =IF(A1>0,"Yes","") where A1 is zero looks empty but ISBLANK returns FALSE because the cell contains a formula. If you want that cell treated as blank, use A2="" instead of ISBLANK. For the inverse — checking that a cell is not blank — either NOT(ISBLANK(A2)) or A2<>"" works, and both are used as the if-cell-is-not-blank check in workflow formulas. Combining ISBLANK with AND adds a second condition that must also be true; combining with OR triggers the result when any one of several conditions is met.
Examples
1
Show Pending for any task where the Status column is blank, and show the actual status for rows that have been filled in.
| A | B | C | |
|---|---|---|---|
| 1 | Task | Status | Display |
| 2 | Design mockup | =IF(ISBLANK(B2),"Pending",B2) | |
| 3 | Write copy | Complete | Complete |
| 4 | Review budget | Pending | |
| 5 | Send invoice | In progress | In progress |
| 6 | Update CRM | Pending | |
| 7 | Book venue | Complete | Complete |
Row 2: Pending
— B2 is empty so ISBLANK returns TRUE and IF outputs Pending.
The value_if_false argument is B2 itself, so for rows with a status the formula simply displays whatever is in the Status column. This pattern gives you a clean display column where every row shows either the real status or Pending — no blanks.
2
Return 0 when a score cell is blank so the score column can be used in SUM and AVERAGE without errors.
| A | B | C | |
|---|---|---|---|
| 1 | Student | Raw Score | Score |
| 2 | Alice | 82 | =IF(ISBLANK(B2),0,B2) |
| 3 | Bob | 0 | |
| 4 | Carol | 91 | 91 |
| 5 | Dan | 0 | |
| 6 | Eve | 77 | 77 |
| 7 | Finn | 88 | 88 |
Row 2: 82
— Alice has a score of 82 so ISBLANK is FALSE and IF returns 82. Bob and Dan have blank scores — ISBLANK is TRUE and IF returns 0 for each.
Returning 0 instead of blank means SUM and AVERAGE work correctly on the Score column. A truly blank cell would be ignored by AVERAGE — returning 0 includes those students in the average calculation, which may or may not be what you want depending on whether blank means did not sit the exam or scored zero.
3
Flag a row for review when the Status is blank OR when it contains the placeholder value TBC, combining ISBLANK and OR.
| A | B | C | |
|---|---|---|---|
| 1 | Task | Status | Flag |
| 2 | Design mockup | =IF(OR(ISBLANK(B2),B2="TBC"),"Review","OK") | |
| 3 | Write copy | Complete | OK |
| 4 | Review budget | TBC | Review |
| 5 | Send invoice | In progress | OK |
| 6 | Update CRM | Review | |
| 7 | Book venue | TBC | Review |
Row 2: Review
— B2 is empty so ISBLANK is TRUE, which makes OR return TRUE, and IF outputs Review.
Review budget has TBC in the Status column — it is not blank, but ISBLANK is FALSE and B2="TBC" is TRUE, so OR still returns TRUE and the row is flagged. This pattern catches both missing entries and placeholder values in a single formula.
Common use cases
1. Show a Pending label in a status column wherever the status has not been filled in yet
=IF(ISBLANK(B2),"Pending",B2)
2. Return 0 for missing numeric values so SUM and AVERAGE formulas work without errors
=IF(ISBLANK(B2),0,B2)
3. Suppress a calculation result when a required input cell is empty to avoid showing partial results
=IF(ISBLANK(A2),"",A2*B2)
4. Count rows where a required field is blank as a data-quality metric
=COUNTIF(B2:B100,"")
5. Flag records that need review because a key field is blank or contains a placeholder value
=IF(OR(ISBLANK(B2),B2="TBC"),"Review","OK")
Common errors
ISBLANK returns FALSE for a cell that looks empty
The cell contains a formula that returns an empty string, or it contains a space character. Visually it looks empty but is not truly blank.
Fix: Use A2="" instead of ISBLANK(A2) to also match formula-returned empty strings. Use TRIM(A2)="" to catch cells containing only spaces.
Formula always shows value_if_true even for filled cells
The cell reference in ISBLANK points to the wrong column or row — check that B2 in ISBLANK(B2) refers to the cell being checked, not a different cell.
Fix: Double-check the cell reference in ISBLANK matches the column you are testing for blanks.
Blank cells in a helper column break downstream IF formulas
Returning an empty string "" makes the cell look blank but it still contains a formula, which some strict blank checks treat as non-blank.
Fix: Use truly empty cells where possible, or consistently use ="" for both writing and checking blank values across the sheet.
Tips and variations
Use ISBLANK for readability and A2="" for formula-returned blanks
ISBLANK clearly communicates the intent — checking for empty cells. But when the column may contain formulas that return "" as a false branch, A2="" is more reliable. I keep both patterns ready and choose based on whether the source column uses formulas.
=IF(A2="","Missing",A2)
Combine with COUNTBLANK for a data-completeness summary
COUNTBLANK counts blank cells in a range — pair it with IF column flags to get both a visual row-level indicator and a numeric summary at the top of the column. This is the foundation of every data-quality dashboard I build.
=COUNTBLANK(B2:B100)
Use NOT(ISBLANK) to check if a cell has content
The inverse of this pattern — NOT(ISBLANK(A2)) — is the if-cell-is-not-blank check used to confirm a required field has been filled before allowing a row to proceed. It reads more naturally than A2<>"" when shared with non-technical users.
=IF(NOT(ISBLANK(B2)),"Ready","Incomplete")
Related reading
Frequently asked questions
Use =IF(A2="","Blank","Not blank") or the cleaner =IF(ISBLANK(A2),"Blank","Not blank"). Both detect empty cells. ISBLANK is more readable and widely understood. The key difference is that ISBLANK returns TRUE only for truly empty cells, while ="" also matches cells containing a formula that returns an empty string.
ISBLANK(A2) returns TRUE only when the cell is completely empty — no content, no formula. A2="" returns TRUE both for empty cells AND for cells that contain a formula returning an empty string, such as =IF(A1>0,"Yes",""). Use ISBLANK when you need to detect cells that genuinely have nothing in them. Use =A2="" when formula-returned empty strings should also be treated as blank.
Use an empty string as the value_if_false argument: =IF(A2>100,"Over budget",""). The two double quotes with nothing between them produce a blank-looking cell. The cell is not truly empty — it contains a formula — but it displays as blank and most formulas treat it as empty for display purposes.
Yes — combine ISBLANK with AND inside IF: =IF(AND(ISBLANK(B2),C2>0),"Missing status","OK"). This returns the message only when B2 is blank AND C2 is positive. You can also use OR to flag a cell when it is blank OR equals a specific value: =IF(OR(ISBLANK(B2),B2="N/A"),"Check","OK").
The cell contains a formula that returns an empty string — such as =IF(A1>0,"Yes","") — or it contains a space character. Visually it appears empty but technically has content. ISBLANK returns FALSE in these cases. Use A2="" instead if you want to treat formula-returned empty strings as blank, or check for a space with TRIM(A2)="".