CEILING macro
The CEILING
macro
is available only in Unica Campaign.
Syntax
CEILING(data)
Parameters
data
The
numerical values to compute the ceiling of. 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
CEILING
calculates
the ceiling of the values in the specified data range. The ceiling
of a number is the smallest integer not less than the number. CEILING
returns one new column for each input column, each containing the
ceiling of numbers in the corresponding input column.
Examples
TEMP = CEILING(4.3) Creates
a new column named |
TEMP = CEILING(2.9) Creates
a new column named |
TEMP = CEILING(V1) Creates
a new column named |
TEMP = CEILING(V1:V3)
Creates three new columns named |
TEMP = CEILING(V1[10:20])
Creates a new column named |
TEMP = CEILING(V1[50:99]:V2)
Creates two new columns named |
Related functions
Function | Description |
---|---|
FLOOR or INT |
Computes the floor of each value in the specified data range |
FRACTION |
Returns the fractional part of each value in the specified data range |
TRUNCATE |
Returns the non-fractional part of each value in the specified data range |