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

The function returns BLANK if the test condition is not satisfied. The condition tests a column formatted as text, list, time period, or date.

## Syntax

`IF (y) THEN (x) ELSE BLANK`

where:

• y: the test condition
• x: a text, list, time period, or date result to return if TRUE

## Format

Input Format Output Format
x: Text, list item, time period, date Matches the data format used by argument x

## Arguments

The function uses the following arguments:

• y: Expression that equates to a Boolean result

## Constraints

The function has the following constraints:

• Result must be text, list, time period, or date-formatted.

## Excel equivalent

• No Excel equivalent

## Example

### List-formatted result

In this example, the Health Plan result line item is list-formatted on the Health Plan list and the Single list item is returned, if the condition on the Health Coverage Points number-formatted line item is satisfied, otherwise Health Plan is left blank:

`IF Health Coverage Points > 100 THEN Health Plan.Single ELSE BLANK`

### Time period-formatted result

In this example, the Product Launch Month result line item is time period-formatted and Mar 14 is returned if the condition on the Product R&D Score number-formatted line item is satisfied, otherwise Product Launch Month is blank:

`IF 'Product R&D Score' < 100 THEN TIME.'Mar 14' ELSE BLANK`

### Date-formatted result

In this example, the Product Launch Date result line item is date-formatted and 01/03/2015 is returned if the condition on the Product R&D Score number-formatted line item is satisfied, otherwise Product Launch Date is blank:

`IF 'Product R&D Score' < 100 THEN DATE(2015, 3, 1) ELSE BLANK`

Note: Date formatting depends on your locale.

### Text-formatted result

In this example, the Product Readiness result line item is text-formatted and Ready to Launch is returned if the condition on the Product R&D Score number-formatted line item is satisfied, otherwise Product Readiness is blank:

`IF 'Product R&D Score' >= 100 THEN 'Ready to Launch' ELSE BLANK`