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
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.
First, select an empty cell. This cell will be used to determine whether another cell in the sheet is not empty.
Type the ISBLANK function with the target cell as the sole argument. In this example, we want to know if cell F2 is blank.
Hit the Enter key to evaluate the ISBLANK function.
In this case, the ISBLANK function returns FALSE, indicating that the cell is not empty.
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.
Our formula should now return TRUE if the cell is not empty.
Use the Fill Handle tool to copy the formula down the rest of the table.
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.