Table of Contents
To check if a cell is empty in Google Sheets, you can use the ISBLANK function. This function evaluates a cell and returns a TRUE or FALSE value depending on whether the cell is empty or not. This is useful for verifying the presence of data in a specific cell, which can be used for conditional formatting, data validation, and other spreadsheet functions. To use the ISBLANK function, simply enter it in a cell and specify the cell you want to check as the argument. This will help ensure the accuracy and completeness of your data in Google Sheets.
Check if Cell is Empty in Google Sheets
You can use the following formulas to check if cells are empty in Google Sheets:
Method 1: Check if One Cell is Empty
=IF(ISBLANK(A1),"Empty","Not Empty")
If cell A1 is empty, this formula returns “Empty” and if it’s not then the formula returns “Not Empty.”
Method 2: Check if Multiple Cells are Empty
=IF(AND(ISBLANK(A1), ISBLANK(B1)),"Empty","Not Empty")
If cells A1 and B1 are both empty, this formula returns “Empty.” Otherwise, it returns “Not Empty.”
The following examples show how to use each method in Google Sheets.
Example 1: Check if One Cell is Empty
Suppose we have the following dataset in Google Sheets that shows the number of points scored by various basketball players:
We’ll use the following formula to check if each cell in column A is empty:
=IF(ISBLANK(A2),"Empty","Not Empty")
We’ll type this formula into cell B2 and then copy and paste it down to every remaining cell in column B:
The values in column B tell us whether each corresponding value in column A is empty or not.
Example 2: Check if Multiple Cells are Empty
We’ll use the following formula to check if the cell in both column A and column B are empty:
=IF(AND(ISBLANK(A2), ISBLANK(B2)),"Empty","Not Empty")
We’ll type this formula into cell C2 and then copy and paste it down to every remaining cell in column C:
The values in column C tell us whether or not both corresponding values in column A and column B are empty.
Note: You can find the complete documentation for the ISBLANK function in Google Sheets .
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets:
Cite this article
stats writer (2024). How can I check if a cell is empty in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-check-if-a-cell-is-empty-in-google-sheets/
stats writer. "How can I check if a cell is empty in Google Sheets?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-check-if-a-cell-is-empty-in-google-sheets/.
stats writer. "How can I check if a cell is empty in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-check-if-a-cell-is-empty-in-google-sheets/.
stats writer (2024) 'How can I check if a cell is empty in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-check-if-a-cell-is-empty-in-google-sheets/.
[1] stats writer, "How can I check if a cell is empty in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I check if a cell is empty in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.