Skip to main content

​​​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!

 

 

Be the first to reply!