Function::Mathematical

Ceil

ceil(numerical field)
ceil(numerical value)
ceil(3.42232)
ceil(-4.3232)
ceil(myvalue*yourvalue)

The ceil function rounds up a numeric value to the next integer. The opposite function is Floor.

Parameters

Numeric value. Decimal

Returns/Result

Numeric value. Integer

Examples

Example 1

ceil(4.5)

Result: 5

Example 2

ceil(4.0)

Result: 4

Example 3

We use a field in this example called MyField and our goal is to get the function to round up if the decimal value is larger than x.5 and down if it smaller than x.5

ceil(MyField-0.5)

For MyField= 4.51 {ceil(4.01)}

Result: 5

For MyField= 4.49 {ceil(3.99)}

Result: 4

Reference

ceil

Type

Math Function

Purpose

The ceil function rounds up a numeric value to the next integer.

Syntax

ceil( NUMERIC VALUE)

Returns

An integer value.

Usage

The numeric value in a Math function can be a constant value (as shown below), a variable, a field value or an expression.

Examples

ceil(5.000)

Returns:5

ceil(5.001)

Returns:6

Function::Mathematical

Parameters

Returns/Result

Examples

Reference

ceil

Type

Purpose

See Also

On the forum about Ceil

On the blog about Ceil