Google Sheets: How to Use ISBLANK with Cell Range


You can use the following formulas to check if cells in a range are blank in Google Sheets:

Method 1: Check if All Cells in Range Are Blank

=AND(ARRAYFORMULA(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(ARRAYFORMULA(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 Google Sheets.

Example 1: Check if All Cells in Range Are Blank

Suppose we have the following dataset in Google Sheets 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(ARRAYFORMULA(ISBLANK(A2:C2)))

We’ll then copy and paste this formula down to every remaining cell in column D:

Google Sheets check if all cells in range are blank

From the output we can see that the only row to return TRUE is row 8, which contains blank values in each column.

Example 2: Check if Any Cells in Range Are Blank

Once again suppose we have the following dataset in Google Sheets:

We’ll type the following formula into cell D2 to check if any cell in row 2 is blank:

=OR(ARRAYFORMULA(ISBLANK(A2:C2)))

We’ll then copy and paste 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.

Note: You can find the complete documentation for the ISBLANK function in Google Sheets here.

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Use “If Contains” in Google Sheets
How to Use ISERROR in Google Sheets
How to Ignore #N/A Values with Formulas in Google Sheets

Leave a Reply

Your email address will not be published.