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