ISODD macro

The ISODD macro is available only in HCL® Campaign.

Syntax

ISODD(data)

Parameters

data

The numerical values to test if they are odd. 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

ISODD tests each value in the specified data set for oddness. It returns one new column for each input column, each containing a one for all odd values (that is, the value modulo two is one) or a zero for all non-odd values (that is, even values).

Note: For non-integer values, the macro function INT is applied first. For example,

ISODD(2.5)
= 0

, since 2 is not odd.

Examples


`TEMP = ISODD(-3)` Creates a new column named `TEMP` containing the value one.
`TEMP = ISODD(V1)` Creates a new column named `TEMP`, where each value is the result of testing the contents of column `V1` for oddness.
`TEMP = ISODD(V1:V3)` Creates three new columns named `TEMP`, `VX`, and `VY`. The values in the `TEMP` column are the results of testing the contents of column `V1` for oddness, the values of the `VX` column are the results of testing the contents of column `V2` for oddness, and the values of the `VY` column are the results of testing the contents of column `V3` for oddness.
`TEMP = ISODD(V1[10:20])` Creates a new column named `TEMP`, where the first 11 cells contain the results of testing the values in rows 10-20 of column `V1` for oddness. The other cells in `TEMP` are empty.
`TEMP = ISODD(V1[1:5]:V2)` Creates two new columns named `TEMP` and `VX`, each with values in rows 1-5 (the other cells are empty). The values in column `TEMP` are the results of testing the corresponding rows of column `V1` for oddness, and the values in column `VX` are the results of testing the corresponding rows of column `V2` for oddness.

Related functions


Function	Description
`ISEVEN`	Tests if input values are even (that is, divisible by two)