​​​Description
Rounds the first argument up to the number of decimal places specified in the second argument.
Syntax
ROUNDUP(Number [, Number of Digits])
Arguments
Argument | Type | Dimensions | Description |
|---|---|---|---|
Number (required) | Number | Any Dimensions | Number to round up. |
Number of Digits (optional) | Integer or Metric | No Dimension or Dimensions of argument Number | Number of decimal digits to round up to. By default, the argument Number is rounded up to the nearest integer value. Up to 14 decimal places are permitted, whether specified as an integer or through a Metric. |
Returns
Type | Dimensions |
|---|---|
Number | Dimensions of argument Number |
BLANK if Number of Digits is negative or over 14.
Examples
Formula | Result | Description |
|---|---|---|
| 2.2 | 2.19 rounded up with 1 digit is 2.2. |
| 2.2 | 2.11 rounded up with 1 digit is 2.2. |
| 3 | 2.1 rounded up to the nearest integer 3. |
|
| The Number of Digits, -1, is invalid. |
|
| The Number of Digits, 15, is invalid. |
See also
Excel: ROUNDUP
Related articles: ROUND, ROUNDDOWN
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!