​​​Description
Rounds the first argument to the number of decimal places specified in the second argument.
Syntax
ROUND(Number [, Number of Digits])
Arguments
Argument | Type | Dimensions | Description |
|---|---|---|---|
Number (required) | Number | Any Dimensions | Number to round. |
Number of Digits (optional) | Integer or Metric | No Dimension or Dimensions of argument Number | Number of decimal places to round to. By default, the argument Number is rounded 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 | The nearest number from 2.19 with 1 digit is 2.2. |
| 2.1 | The nearest number from 2.11 with 1 digit is 2.1. |
| 3.0 | The nearest number from 2.99 with 1 digit is 3.0. |
| 2.99 | The nearest number from 2.99 with 2 digits is 2.99. |
| 3 | The nearest number from 2.99 with no digits is 3. |
| 2.4 | The nearest number from 2.365 with 1 digit is 2.4. |
|
| The Number of Digits, -1, is invalid. |
|
| The Number of Digits, 15, is invalid. |
See also
Excel: ROUND
Related articles: ROUNDUP, 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!