In this tutorial, you will learn how to check if a cell is not empty in Google Sheets
How to Check if a Cell is Not Empty in Google Sheets
Quick Navigation
When handling data in a spreadsheet, you may encounter fields with blank cells. Empty cells are a common occurrence in all kinds of datasets, however they may be something worth flagging to the user. Fortunately, there is a simple way to check if a cell is not empty in Google Sheets.
The ISBLANK function in Google Sheets allows you to quickly and easily check if a cell is empty or not.
In this guide, we will show you how to use the ISBLANK function in Google Sheets to check if a cell is not empty.
How to Determine if a Cell is Not Blank in Google Sheets
Here’s how to determine if a cell is not blank in Google Sheets.
Step 1
First, select an empty cell. This cell will be used to determine whether another cell in the sheet is not empty.
Step 2
Type the ISBLANK function with the target cell as the sole argument. In this example, we want to know if cell F2 is blank.
Step 3
Hit the Enter key to evaluate the ISBLANK function.
In this case, the ISBLANK function returns FALSE, indicating that the cell is not empty.
Step 4
If you want to return TRUE if the cell is not empty, we can simply wrap the ISBLANK function with a NOT function.
The NOT function reverts all TRUE values to FALSE and vice versa.
Step 5
Our formula should now return TRUE if the cell is not empty.
Step 6
Use the Fill Handle tool to copy the formula down the rest of the table.
Summary
This guide should be everything you need to check if a cell is not empty in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.