You can use the following formulas to check if cells in a range are blank in Excel:
Method 1: Check if All Cells in Range Are Blank
=AND(ISBLANK(A2:C2))
If all cells in the range A2:C2 are blank, this formula returns TRUE.
Otherwise, it returns FALSE.
Method 2: Check if Any Cells in Range Are Blank
=OR(ISBLANK(A2:C2))
If any cells in the range A2:C2 are blank, this formula returns TRUE.
Otherwise, it returns FALSE.
The following examples show how to use each method in Excel.
Example 1: Check if All Cells in Range Are Blank
Suppose we have the following dataset in Excel that contains information about various basketball players:
We’ll type the following formula into cell D2 to check if every cell in row 2 is blank:
=AND(ISBLANK(A2:C2))
We’ll then click and drag this formula down to every remaining cell in column D:
From the output we can see that the only row to return TRUE is row 8, which contains blank values in each column.
All other rows return FALSE since no other row has all blank values.
Example 2: Check if Any Cells in Range Are Blank
Once again suppose we have the following dataset in Excel:
We’ll type the following formula into cell D2 to check if any cell in row 2 is blank:
=OR(ISBLANK(A2:C2))
We’ll then click and drag this formula down to every remaining cell in column D:
From the output we can see that three rows return a value of TRUE.
Each of these rows has at least one blank cell.
Additional Resources
The following tutorials explain how to perform other common tasks in Excel:
Excel: If Cell is Blank then Skip to Next Cell
Excel: How to Fill Blank Cells
Excel: Calculate Average and Ignore Zero and Blank Cells
