How to Check if a Cell is Not Empty in Google Sheets

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.

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.