ISBLANK Function

Checks whether a value is blank.
Sample Usage
IF(ISBLANK([Task Name]1), "Cell is blank", "Cell isn't blank")
Syntax
ISBLANK(
  • value
)
  • value
    The value, typically within a cell, to check.
Usage Notes
  • This function is typically used inside of another function, for example: IF, COUNTIF, or SUMIF.
Examples

This example references the following sheet information (some fields have been left intentionally blank):

  Clothing Item Units Sold In Stock? Status % Complete
1 T-Shirt   true Green 100%
2 Pants 78 true Yellow 25%
3 Jacket 42 false Red  

Given the table above, here are some examples of using ISBLANK in a sheet:

Formula Description Result
=IF(ISBLANK([Units Sold]1), "Blank", "Not blank") Returns the string "Blank" if row 1 of the "Units Sold" column contains no value. Returns "Not blank" otherwise. Blank
=IF(NOT(ISBLANK([Units Sold]2)), "Gained revenue","No Sale") Returns the string "Gained revenue" if row 2 of the "Units Sold" column contains no value. Returns "No sale" if the field is blank. Gained revenue
=IF(ISBLANK([% Complete]3), "Red") Returns "Red" if row 3 of the % Complete column is blank. Red