Last Updated on October 31, 2023 by Jake Sheridan
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.
More ways to clean data in Google Sheets:
- Clear Cells
- Clear Contents
- Clear Formatting
- Clear Filter
- Stop Google Sheets From Rounding
- Remove Dollar Sign
- Stop Google Sheets From Deleting Zeros
- Separate First And Last Name
- Format Phone Numbers
- Change Currency
- Add Dollar Sign
- Split Text To Columns
- Split Text to Rows
- Split Cells
- Split Text
- Find And Replace
- Find And Replace Wildcard
- Swap Cells