Google Sheets ISBLANK Function

This post will guide you how to use Google Sheets ISBLANK function with syntax and examples in Google Spreadsheets.


The Google Sheets ISBLANK function returns TRUE if the value is blank or null.

The ISBLANK function is a build-in function in Google Sheets and it is categorized as an Information Function.


The syntax of the ISBLANK function is as below:

= ISBLANK (value)

Where the ISBLANK function argument is:

  • Value -This is a required argument. The value that you want to test.

Google Sheets ISBLANK Function Examples

The below examples will show you how to use Google Sheets ISBLANK Function to test if the value is blank, if so, return TRUE.

#1 = ISBLANK (B2)

google sheets ISBLANK function1

See Also: Check If a Cell is Blank or Empty in Google Sheets