CEIL

The following section describes the syntax and usage of the CEIL function in ActivityInfo.

Description

The CEIL function is used to round a value upwards to the nearest whole number.

Syntax

CEIL(value)

Argument Required Description
value Yes The value you wish to round upwards.

The value must be numeric.

Result

The nearest whole number when rounding up from the given value.

Example

We will be using the CEIL function to calculate a rounded value from an argument.

Arguments

We will be using the Quantity Field "Value" with Field Code "VAL".

Formula

CEIL(VAL)

Results