Simplicty and flexibility!

# 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

# 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