Returns a Boolean result to a test for whether a date, text, list, or time period-formatted item is blank.
- If TRUE returns selected check box.
- If FALSE returns unselected check box.
Syntax
ISBLANK(x)
where:
- x: Cell to test
Format
| Input Format | Output Format |
|---|---|
|
x: Date, text, list item, time period |
Boolean |
Arguments
The function uses the following arguments:
- x: Date, text, list item, time period, or general expression: line item
Constraints
The function has the following constraints:
- Source must be date, text, list, or time period-formatted.
- Result must be Boolean-formatted.
Excel equivalent
Example
In this example, Health Plan Start Date source is date-formatted and Health Coverage Pending result is Boolean-formatted:
The line item Health Coverage Pending has the formula:
ISBLANK (Health Plan Start Date)
In a second example, Health Plan Start Month source is time period-formatted for months and Health Coverage Pending result is Boolean-formatted:
The line item Health Coverage Pending has the formula:
ISBLANK (Health Plan Start Month)
