ISBLANK function

ISBLANK returns TRUE if a cell is completely empty, FALSE if it contains any value or formula, and propagates errors.

=ISBLANK(value)

Generate a ISBLANK formula

Describe what you need. The generator will reach for ISBLANK where ISBLANK is the right tool, and tell you when it is not.

How to get a better answer
  • Name your columns by letter and by header: "column F (Net Value)" beats "the amount column".
  • State every condition, including the negatives — "not cancelled" changes the formula's shape.
  • Say where the data starts if it is not row 1, and whether it will grow.
  • Check the settings above match your spreadsheet: the wrong argument separator is a syntax error on your machine.

Arguments

How ISBLANK reads its arguments
valuerequiredISBLANK →
ArgumentRequiredDescription
valueRequiredAny cell reference or value to test. If value is an error, ISBLANK returns that error rather than a boolean. Works on single cells only, not ranges.

Returns

Boolean: TRUE if the cell is empty, FALSE otherwise.

Availability

Excel: All · Google Sheets: Supported

Worked examples

1. Check if a support ticket has been closed

Ticket IDPriorityOpenedClosedAgentCSAT
T-001High2025-01-052025-01-06Alice5
T-002Low2025-01-10Bob
T-003Critical2025-01-152025-01-17Alice4
=ISBLANK(D2)

Result: FALSE (T-001, T-003); TRUE (T-002)

ISBLANK checks if the Closed column (D) is empty. T-002 has no closed date, returning TRUE to flag it as still open. T-001 and T-003 have dates, returning FALSE. This quickly identifies unclosed tickets.

2. Find tickets missing customer satisfaction ratings

Ticket IDPriorityOpenedClosedAgentCSAT
T-001High2025-01-052025-01-06Alice5
T-002Low2025-01-102025-01-11Bob
T-003Critical2025-01-152025-01-17Alice4
=ISBLANK(F2)

Result: FALSE (T-001, T-003); TRUE (T-002)

Checking CSAT (column F) row by row reveals which resolved tickets lack feedback. T-002's CSAT cell is empty, so ISBLANK returns TRUE, signaling incomplete follow-up data even though the ticket itself is closed.

3. Create a helper column with readable ticket status labels

Ticket IDPriorityOpenedClosedAgentCSATStatus
T-001High2025-01-052025-01-06Alice5CLOSED
T-002Low2025-01-10BobOPEN
T-003Critical2025-01-152025-01-17Alice4CLOSED
=IF(ISBLANK(D2),"OPEN","CLOSED")

Result: "CLOSED", "OPEN", "CLOSED"

Combining ISBLANK with IF creates a readable status column. When the Closed date is blank, it outputs "OPEN"; otherwise "CLOSED". This is far clearer than asking users to interpret blank cells directly.

Common errors

Which ISBLANK error are you seeing?
ISBLANK returned an error#REF!
Restore the deleted column or update the formula to reference an existing cell, such as D2 (Closed) or F2 (CSAT).
#N/A
Wrap the lookup in IFERROR before ISBLANK: =ISBLANK(IFERROR(VLOOKUP(...),"")) to replace #N/A with an empty string.
#NULL!
Use valid syntax: =ISBLANK(D2) for a single cell, or fix multi-cell references with proper operators (colon for ranges, comma for separate cells).
ErrorWhy it happensHow to fix it
#REF!You referenced a deleted column or broken cell address. Example: =ISBLANK(E2) fails if column E was deleted after your formula was written.Restore the deleted column or update the formula to reference an existing cell, such as D2 (Closed) or F2 (CSAT).
#N/AThe value passed to ISBLANK is itself a #N/A error, typically from a failed lookup. Example: =ISBLANK(VLOOKUP(agent,table,3)) when the agent is not found.Wrap the lookup in IFERROR before ISBLANK: =ISBLANK(IFERROR(VLOOKUP(...),"")) to replace #N/A with an empty string.
#NULL!Incorrect range syntax, such as =ISBLANK(D2 E2) with a space instead of a colon or comma, or referencing two non-adjacent ranges without proper separation.Use valid syntax: =ISBLANK(D2) for a single cell, or fix multi-cell references with proper operators (colon for ranges, comma for separate cells).

Tips and when to use something else

  • ISBLANK returns TRUE only for completely empty cells. A cell containing a formula that outputs an empty string ("") is not blank by ISBLANK's definition.
  • For checking multiple columns at once, use COUNTBLANK(D2:F2)>0 instead of nesting ISBLANK calls; it's clearer and more efficient.
  • Use ISBLANK with IF to create readable outputs: =IF(ISBLANK(D2),"Pending","Resolved") is more informative than raw blank/non-blank cells.
  • Don't confuse ISBLANK with ISNA or ISERROR—they detect different conditions. Use ISNA for #N/A errors, ISERROR for any error type, and ISBLANK only for empty cells.

Related functions

COUNTBLANKCOUNTBLANK returns the number of empty cells in a specified range, useful for identifying incomplete data or tracking active subscriptions.IFThe IF function returns one value if a condition is true and another (or nothing) if it is false, letting you branch logic in a cell.IFERRORIFERROR returns the result of a formula unless that formula generates an error, in which case it returns a user-specified alternative value.ISNAISNA detects whether a value is the #N/A error, typically returned when a lookup function fails to find a match.ISERRORISERROR returns TRUE if a value is an error like #N/A or #REF!, FALSE otherwise, enabling error detection and handling.

Frequently asked questions

Does ISBLANK detect cells containing empty formulas like ="" ?
No. A cell with the formula ="" (empty string) returns FALSE because the formula itself is content. ISBLANK only detects truly empty cells with no value or formula. To detect empty strings, use =LEN(A1)=0 or =IF(A1="",TRUE,FALSE) instead.
Can I use ISBLANK to check multiple cells in a range at once?
ISBLANK only works on single cells. For a range, use COUNTBLANK(D2:D100) to count blank cells, or combine multiple ISBLANK calls with AND/OR: =AND(ISBLANK(D2),ISBLANK(F2)) to check if both the Closed date and CSAT are missing.
What's the difference between ISBLANK and checking if a cell equals an empty string?
ISBLANK returns TRUE for completely empty cells with no content or formula. Checking =A1="" returns TRUE for cells containing empty string results or values. A cell with ="" inside is not blank to ISBLANK, but it does equal an empty string.
How can I use ISBLANK in conditional formatting to highlight incomplete tickets?
In Google Sheets, create a custom formula rule using =ISBLANK(D2) to highlight rows where the Closed date is missing. In Excel, use the same approach with conditional formatting custom rules. Apply it to the range and adjust the row reference accordingly.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17