Description
Rounds up a Number to the nearest Integer value.
Syntax
CEILING(Number to Round Up)
Arguments
Argument | Type | Dimensions | Description |
---|---|---|---|
Number to Round Up (required) | Number | Any Dimensions | Decimal number to round up. |
Returns
Type | Dimensions |
---|---|
Number | Dimensions of Number to Round Up |
Examples
Formula | Result | Description |
---|---|---|
CEILING(2.36) | 3 | The nearest integer up of 2.36 is 3. |
CEILING(-2.36) | -2 | The nearest integer up of -2.36 is -2. |
See also
Excel: CEILING.MATH
Related articles: FLOOR
More of a hands-on learner?
Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!
