ISERROR macro

The ISERROR macro is available only in Unica Campaign.

Syntax

ISERROR(data)

Parameters

data

The values to test if any of the rows contain an error (that is, a ??? cell). This can be a constant value, a column, a cell range, or an expression evaluating to any of the above. For the format definition of data, see the "Macro Function Parameters" section in the chapter in this guide for your product.

Description

ISERROR checks if any cell of each row of the specified data range contains an error (that is, a ??? cell). It returns one new column, each row containing a one if the corresponding row of data contains an error. Otherwise, it contains a zero. This row-by-row calculation produces a result for each row up to the last value of the longest column.

Examples

TEMP = ISERROR(-3)

Creates a new column named TEMP containing the value zero.
TEMP = ISERROR(V1)

Creates one new columns named TEMP, where each value is a one if the corresponding row of column V1 contains ???, otherwise, a zero.
TEMP = ISERROR(V1:V3)

Creates one new columns named TEMP, where each value is a one if any of the cells in the corresponding rows of column V1 - V3 contains ???, otherwise, a zero.
TEMP = ISERROR(V1[50:100]:V10)

Creates one new columns named TEMP, with values in rows 1-50. Each value is a one if any of the cells in rows 50-100 of columns V1 - V10 contains ???, otherwise, a zero.