Google Sheets ISBLANK Function

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

Description

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.

Syntax

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

Related Posts

Add Row Numbers And Skip Blanks in Google Sheets

Do you ever have to input a list of numbers into a spreadsheet in Google Sheets, and some of the cells are blank? It can be difficult to keep track of what number is in which cell when you have ...

Google Sheets Nexted IF Functions (Statements) Tutorial (15 IF Formulas examples)

This tutorial will guide you how to use nested Google Sheets IF function  (include multiple If statements in Google Sheets formula) with syntax and provide about 15 nested IF formula examples with the detailed explanation in Google Spreadsheets. Description The ...

Google Sheets IF Function

This post will guide you how to use Google Sheets IF function with syntax and examples in Google Spreadsheets. Description The Google Sheets IF function perform a logical test to return one value if the condition is TRUE and return ...

Check If a Cell is Blank or Empty in Google Sheets

The article demonstrates how to check if a range of cells is blank or empty by ISBLANK and other functions to recognize empty cells in Google Spreadsheets and take appropriate action based on their status. There are several circumstances in ...

Sidebar