Tests to see if an item is not blank, where the item is date, text, list, or time period-formatted. Returns a Boolean result as checkbox:
- If item is not blank, returns a marked check box = TRUE
- If item is blank, returns an unmarked check box = FALSE
Syntax
ISNOTBLANK(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: Hard-coded date, date variable, text-formatted line item, text constant, numeric line item, property, or general expression
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 source is text-formatted and Health Plan Month result is Boolean-formatted:
ISNOTBLANK(Health Plan)
In a second example, Health Plan Start Month source is time period-formatted for months and Health Plan Coverage result is Boolean-formatted:
ISNOTBLANK(Health Plan Start Month)
