ISBLANK

The following section describes the syntax and usage of the ISBLANK function in ActivityInfo.

Description

The ISBLANK function is used to determine whether a value is blank.

Syntax

ISBLANK(value)

Argument Required Description
value Yes The value you wish to test is blank.

Result

  • TRUE if the value is a blank.
  • FALSE if the value is not blank.

Example

We will be using the ISBLANK function to evaluate whether a value is blank, and using the IF function to return a value.

Arguments

We will be using the Quantity Field "Age" with Field code "AGE". Note the blank Record in the beginning.

Formula

if(ISBLANK(AGE), 1, 0)

Results