How to Check if Cell is Empty in Google Sheets

To check if a cell is empty in Google Sheets, you can use the ISBLANK() function. The ISBLANK() function returns TRUE if the cell is empty and FALSE if it contains any value.

Here's how to use the ISBLANK() function:

1. Click on the cell where you want the result to be displayed.
2. Enter the formula =ISBLANK(cell_reference), where cell_reference is the address of the cell you want to check.
3. Press Enter.

The formula will return TRUE if the referenced cell is empty and FALSE if it contains any value.

Example

Let's say you want to check if cell A1 is empty. Here's how to do it:

1. Click on the cell where you want the result to be displayed (e.g., B1).
2. Enter the formula =ISBLANK(A1).
3. Press Enter.

The formula in B1 will return TRUE if A1 is empty and FALSE if it contains any value.