Easy to Create, Easy to Change - Easy to use!

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

ceil

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