ISBLANK
Formulas / ISBLANKDetermine 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?
How can I use the ISBLANK function?
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("")
