Description
Rounds the given Number to the nearest number with the given number of digits.
Syntax
ROUND(Number N, Number of Digits])
Arguments
| Argument | Type | Dimensions | Description |
|---|---|---|---|
| Number (required) | Number | Any Dimensions | Number to round. |
| Number of Digits (optional) | Integer | No Dimension or Dimensions of argument Number | Number of decimal digits of the nearest value. By default, the argument Number is rounded to the nearest integer value. |
Returns
| Type | Dimensions |
|---|---|
| Number | Dimensions of argument Number |
BLANK if Number of Digits is a negative integer.
Examples
| Formula | Result | Description |
|---|---|---|
ROUND(2.19, 1) | 2.2 | The nearest number from 2.19 with 1 digit is 2.2. |
ROUND(2.11, 1) | 2.1 | The nearest number from 2.11 with 1 digit is 2.1. |
ROUND(2.99, 1) | 3.0 | The nearest number from 2.99 with 1 digit is 3.0. |
ROUND(2.99, 2) | 2.99 | The nearest number from 2.99 with 2 digits is 2.99. |
ROUND(2.99) | 3 | The nearest number from 2.99 with no digits is 3. |
ROUND(2.365, 1) | 2.4 | The nearest number from 2.365 with 1 digit is 2.4. |
ROUND(1.11, -1) | BLANK | The Number of Digits, -1, 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!
