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(<?php Complete]3), "Red")</td> |