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 |