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

Test to see if a date, text, time period, or list-formatted cell is not blank.

For a number-formatted cell, use a numeric formula such as >0.

Syntax

IF ISNOTBLANK(x) THEN 1 ELSE 0 

where:

  • x: Cell to test

Format

Input Format Output Format
x: Number, text, list item, time period, date Boolean

Arguments

The function uses the following arguments:

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

Constraints

The function has the following constraints:

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

Excel equivalent

Back to Top

Example

IF ISNOTBLANK(c) THEN 1 ELSE 0

Returns 1 if line item c is not blank, returns 0 if line item c is 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 ISNOTBLANK function in the Employee Deduction(%Salary) number-formatted result line item against the Health Plan source to show the required percentage 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 Score line item tracks product preparedness towards a score of 100, which will allow product launch. While R&D work remains, the time period-formatted Product Launch Month line item shows the scheduled launch month of Mar 14. We can now use the IF ISNOTBLANK function in the number-formatted Remaining R&D result line item against the Product Launch Month source to show the R&D shortfall on a month-by-month basis:

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 achieved 100 points in a month and has started on a plan. We can now use the IF ISNOTBLANK 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 ISNOT BLANK function in the number-formatted Health Coverage Bonus result line item against the Health Plan Status source to calculate the extra points an employee is due for each month they are on a health plan:

Number-formatted

For a number-formatted cell use >0.

Back to Top

Similar functions