Ceiling Function

Ceiling Function

Description:
Round a number up (away from zero) to the nearest multiple of a whole number.
Returns:
Whole Number
Parameters:
Parameter
Data Type
Description
1
Number
The number to be rounded.
2
Whole Number
The significant whole number.
Examples:
When using functions inside a field, remember the field brackets:
{Ceiling(VariableName, 1)}
Expression
Result
Ceiling( 6.001, 1 )
7
Ceiling( 6.001, 2 )
8
Ceiling( -6.001, 3 )
-9