Round Down [ROUNDDOWN]

Rounds a number down to a specified number of digits.

If the Number of Digits argument is positive, rounding takes place downward to the specified number of decimal places.

If the Number of Digits argument is zero, the number is rounded downward to the nearest integer.

If the Number of Digits argument is negative, rounding down takes place to the given number of places, to the left of the decimal point.

Syntax

ROUNDDOWN (Number, NumberOfDigits)

Note: The required separator (comma or semi-colon) automatically corresponds to your computer’s location settings.

Data Types of the Arguments

Number: Integer, Number

Number of Digits: Integer

Data Type of the Result

Number

Example

Expression 1

ROUNDDOWN (46.9855, 2)

Result

46.98

Expression 2

ROUNDDOWN (46.9855, 0)

Result

46.00

Expression 3

ROUNDDOWN (46.9855, -1)

Result

40.00

Notes

See also: Round [ROUND], Round Up [ROUNDUP].

To round to a certain multiple, use Round to Multiple [MROUND] (or Round Up to Multiple [MROUNDUP] or Round Down to Multiple [MROUNDDOWN]).