ISBLANK Function in Google Sheets

Check if a cell is empty using the ISBLANK function.

ISBLANK Function

The ISBLANK function in Google Sheets is used to check if a cell is empty.

Syntax

ISBLANK(value)
  • value: The cell or value you want to check. This is a required parameter.

Example

  1. Check If Cell is Empty

Check if cell A1 is empty:

=ISBLANK(A1)

This will return TRUE if A1 is empty, and FALSE otherwise.

Notes

  • The function is useful for conditional formatting or logical tests.
  • IF: Perform a logical test based on whether a cell is blank.