Description
Rounds down the given Number to a given number of digits.
Syntax
ROUNDDOWN(Number N, Number of Digits])
Arguments
Argument | Type | Dimensions | Description |
---|---|---|---|
Number (required) | Number | Any Dimensions | Number to round down. |
Number of Digits (optional) | Integer | No Dimension or Dimensions of argument Number | Number of decimal digits to round down to. By default, the argument Number is rounded down 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 |
---|---|---|
ROUNDDOWN (2.19, 1) | 2.1 | 2.19 rounded down with 1 digit is 2.1. |
ROUNDDOWN (2.11, 1) | 2.1 | 2.11 rounded down with 1 digit is 2.1. |
ROUNDDOWN (2.9) | 2 | 2.9 rounded down to the nearest integer is 2. |
ROUNDDOWN (1.11, -1) | BLANK | The Number of Digits, -1, 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!
