1. Calculation functions
  2. All Functions
  3. Logical Functions
  4. ISNOTBLANK

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

Back to Top

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)

Back to Top

Similar functions