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

Tests whether a date, text, time period, or list-formatted cell is blank.

For a number-formatted cell, use a numeric formula such as <1.

Syntax

IF ISBLANK(x) THEN 1 ELSE 0 

where:

  • x: Cell to test.

Format

Input Format Output Format

x: Text, list item, time period, date

Boolean

Arguments

The function uses the following arguments:

  • x: Number, text, list, time period, or date-formatted line item, property, or expression.

Constraints

The function has the following constraints:

  • Source must be text, list, time period, or date-formatted line item.

Excel equivalent

Back to Top

Example

IF ISBLANK(c) THEN 1 ELSE 0

Returns 1 if line item c is blank, returns 0 if line item c is not blank.

List-formatted

In this example, a Health Plans module has time on columns and the Sales Personnel list on pages. Employees are put on a plan, if they achieve 100 health coverage points in any given month and employees on a plan have 3.5% of their salary deducted. The Health Plan line item is list-formatted on the Health Plan list and shows when an employee has been put on a plan, based on points earned each month. We can now use the IF ISBLANK function in the Employee Deduction(%Salary) number-formatted result line item against the Health Plan source to show the required salary reduction:

Time period-formatted

In this example, a Product Planning module has time on columns and the Products list on pages. The Product R&D Scoreline item tracks product preparedness towards a score of 100, which will allow product launch. Product Launch Month is time period-formatted and shows Mar 14, until the Product R&D Score reaches 100. We can now use the IF ISBLANK function in the text-formatted Product Launched result line item against Product Launch Month as source to mark when the product was launched:

Date-formatted

In this example, a Health Plans module has time on columns and the Sales Personnel list on pages. Employees are put on a plan, if they achieve 100 health coverage points in any given month. A date-formatted Health Plan Start Date line item has a date entered, only if the employee has started on a plan. We can now use the IF ISBLANK function in the number-formatted Health Coverage Shortfall result line item against the Health Plan Start Date source to calculate the points shortfall for months in which the employee does not reach 100 points:

Text-formatted

In this example, a Health Plans module has time on columns and the Sales Personnel list on pages. Employees are put on a plan, if they achieve 100 health coverage points in any given month. A text-formatted Health Plan Status line item shows when an employee is on a health plan. We can now use the IF ISBLANK function in the number-formatted Health Coverage Bonus result line item against the Health Plan Status source to calculate the extra points due to an employee for each month they are on a health plan:

Number-formatted

For a number-formatted cell use <1.

Back to Top

Similar functions