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

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

Here’s how to check if a particular cell is not empty in Google Sheets.

Step 1

Our goal is to return either a TRUE or FALSE value depending on whether a particular cell is empty.

To start, we’ll first need to create a new column to place our boolean results.

Step 2

Next, we’ll use the formula =NOT(ISBLANK(<cell>)) to determine whether the target cell is not empty.

The ISBLANK function returns TRUE only when the cell is empty. The NOT function is used to return the opposite boolean result. Thus, using both will allow the formula to return TRUE only when the cell is found to not be empty.

Step 3

We can use the NOT and ISBLANK formula together as a condition for the IF function.

Instead of always returning TRUE or FALSE, the user can specify custom strings as output.

Step 4

Another easy way to check if a cell is not empty is by referencing the cell and using the “<>” operator to compare it to an empty string.

For example, the formula =D2<>”” will only return TRUE if D2 is not blank.

Summary

This guide should be everything you need to know 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.