Rounds a number down to the specified number of digits.

Usage

RoundDown(number, [digits])

number (required) The number to be rounded.

digits [optional] The number of decimal places to which to round.
If "digits" value is negative, the function will return an integer with that many least-significant digits zeroed (see example 4 below).

 

Example

(1) Returns 3.14

RoundDown(3.141, 2)

(2) Returns -6.255.

RoundDown(-6.25417, 3)

(3) Rounds the value for each row in the input column down. Numbers are rounded by 2 digits.

RoundDown([Cost], 2)

Screen_Shot_2020-12-01_at_10.21.48_AM.png

(4) Rounds the input number down and replaces its last 2 digits with 0s.  A negative "digits" value returns an integer with that many least-significant digits zeroed. 

RoundDown([Cost], -2)

Screen_Shot_2020-12-01_at_10.21.24_AM.png

 

See Also

Floor - Rounds the input number up to the closest multiple of equal or lesser value. 

Round - Rounds the input number to the specified number of digits.

RoundUp - Rounds a number up to the specified number of digits.

MRound - Rounds the input number to the closest multiple of the given factor.

Ceiling - Rounds the input number up to the closest multiple of equal or greater value.