Table of Contents
The ISBLANK function in Excel is a useful tool that allows users to check whether a specific cell is empty or not. This can be especially helpful when working with large amounts of data in a spreadsheet. To use the ISBLANK function with a cell range, simply select the desired range of cells and enter the ISBLANK formula. The function will then return a TRUE or FALSE value for each cell in the selected range, indicating whether it is blank or not. This can save time and effort when working with large sets of data, as it eliminates the need to manually check each individual cell.
Excel: Use ISBLANK with Cell Range
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:
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: