# 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` containing the value `5`. `TEMP = CEILING(2.9)` Creates a new column named `TEMP` containing the value `-2`. `TEMP = CEILING(V1)` Creates a new column named `TEMP`, where each value is the ceiling of the contents of column `V1`. `TEMP = CEILING(V1:V3)` Creates three new columns named `TEMP`, `VX`, and `VY`. The values in the `TEMP` column are the ceilings of the contents of column `V1`, the values of the `VX` column are the ceilings of the contents of column `V2`, and the values of the `VY` column are the ceilings of the contents of column `V3`. `TEMP = CEILING(V1[10:20])` Creates a new column named `TEMP`, where the first 11 cells contain the ceilings of the values in rows 10-20 of column `V1`. The other cells in `TEMP` are empty. `TEMP = CEILING(V1[50:99]:V2)` Creates two new columns named `TEMP` and `VX`, each with values in rows 1-50 (the other cells are empty). The values in column `TEMP` are the ceilings of the rows of column `V1`, and the values in column `VX` are the ceilings of the values in column `V2`.

## 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