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 |
Related Content
-
Arithmetic Functions
Format:
Article,
1 min read