ISBLANK

Sample Usage

Syntax

ISBLANK returns TRUE if value is empty or a reference to an empty cell, and FALSE if it contains data or a reference to data.

Notes

ISBLANK returns FALSE if the referenced cell has any content, including spaces, the empty string (""), and hidden characters. In case of unexpected FALSE results, try clearing the cell again to remove any hidden characters.

This function is most often used in conjunction with IF in conditional statements.

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.