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
