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