6.2 C
London
Thursday, December 19, 2024
HomeSoftware TutorialsGoogle SheetsGoogle Sheets: How to Use ISBLANK with Cell Range

Google Sheets: How to Use ISBLANK with Cell Range

Related stories

Learn About Opening an Automobile Repair Shop in India

Starting a car repair shop is quite a good...

Unlocking the Power: Embracing the Benefits of Tax-Free Investing

  Unlocking the Power: Embracing the Benefits of Tax-Free Investing For...

Income Splitting in Canada for 2023

  Income Splitting in Canada for 2023 The federal government’s expanded...

Can I Deduct Home Office Expenses on my Tax Return 2023?

Can I Deduct Home Office Expenses on my Tax...

Canadian Tax – Personal Tax Deadline 2022

  Canadian Tax – Personal Tax Deadline 2022 Resources and Tools...

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

Subscribe

- Never miss a story with notifications

- Gain full access to our premium content

- Browse free from up to 5 devices at once

Latest stories