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