ISEVEN macro
The ISEVEN
macro
is available only in HCL®
Campaign.
Syntax
ISEVEN(data)
Parameters
data
The
numerical values to test if they are even. 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 HCL
product.
Description
ISEVEN
tests
each value in the specified data set for evenness. It returns one
new column for each input column, each containing a one for all even
values (that is, the value modulo two is zero) or a zero for all non-even
values (that is, odd values).
INT
is applied first.
For example, ISEVEN(2.5) = 1
, since 2
is even.Examples
TEMP = ISEVEN(-3) Creates
a new column named |
TEMP = ISEVEN(V1) Creates
a new column named |
TEMP = ISEVEN(V1:V3) Creates
three new columns named |
TEMP = ISEVEN(V1[10:20])
Creates a new column named |
TEMP = ISEVEN(V1[1:5]:V2)
Creates two new columns named |
Related functions
Function | Description |
---|---|
ISODD |
Tests if input values are odd (that is, not divisible by two) |