ISBLANK

Formulas / ISBLANK
Determine if a cell is empty.
=FALSE
  • value - required argument that may be a blank cell, error, logical value, text, number, or reference value.

Examples

  • =ISBLANK(A1)

    The ISBLANK function can be used to determine whether a cell is empty or not. This example will return TRUE if A1 is blank, or FALSE if A1 is not blank.

  • =ISBLANK(A2)

    The ISBLANK function can also be used to determine if a cell contains text. This example will return FALSE if A2 contains text, or TRUE if A2 is empty.

  • =IF(ISBLANK(A1), "Cell is blank", "Cell is not blank")

    The ISBLANK function can be used in conjunction with other Sourcetable functions, such as the IF function. This example will return "Cell is blank" if A1 is blank, or "Cell is not blank" if A1 is not blank.

  • =COUNTIF(A1:A10, ISBLANK(A1:A10))

    The ISBLANK function can be used to count the number of blank cells in a range. This example will count the number of blank cells in the range.


Summary

The ISBLANK function is a useful tool to quickly determine if a cell is blank. It returns a boolean value that indicates whether the cell is empty or not.

  • The ISBLANK function returns TRUE if a cell is not empty and takes one argument, which is a value like A1.
  • The syntax <>"" can be used to test if a cell is empty or not and may be used interchangeably with ISBLANK.

Frequently Asked Questions

What is the ISBLANK function?
The ISBLANK function returns whether a cell is blank. It is useful for checking if a cell is blank without displaying a formula result.
How can I use the ISBLANK function?
The ISBLANK function can be used with IF to check if a cell is blank. The "" argument of the ISBLANK function is useful for determining if a cell is blank without a formula calculation.
What are some examples of using the ISBLANK function?
  • Checking if a cell is blank in an IF statement:
    =IF(ISBLANK(A1),"Cell is blank","Cell is not blank")
  • Determining if a cell is blank without a formula calculation:
    =ISBLANK("")

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV