Ceil

Returns the whole number greater than or equal to a given number, or returns null if its parameter is null.

Syntax

Ceil(n)

Parameters

Parameter

Description

n

Any numeric value or expression.

The function returns 0 if n is not a numeric value or expression.

Note: FormCalc follows the IEEE-754 international standard when handling floating point numeric values. For more information, see Number literals.

Examples

The following expressions are examples of using the Ceil function:

Expression

Returns

Ceil(2.5875)

3

Ceil(-5.9)

-5

Ceil("abc")

0

Ceil(A)

100 if the value of A is 99.999

// Ethnio survey code removed