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:
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