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

Back to Top

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

Back to Top

Similar functions