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 = ISERROR(V1) Creates one new columns
named |
TEMP = ISERROR(V1:V3) Creates
one new columns named |
TEMP = ISERROR(V1[50:100]:V10) Creates
one new columns named |