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

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

Back to Top

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)
		

Back to Top

Similar functions