ROUNDDOWN

Using the Excel ROUNDDOWN Function

Summary

The Excel ROUNDDOWN function is used to round a number down (towards zero) to a given number of decimal places. Unlike the ROUND function that uses standard rounding rules, ROUNDDOWN will round all numbers (1 - 9) down towards zero. ROUNDDOWN can be used to round numbers to either the left or the right of the decimal place.

Syntax

=ROUNDDOWN (number, num_digits)

Syntax Breakdown

number
The number argument is required in the ROUNDDOWN function and is the number that you want to round down.

num_digits
The num_digits argument is also required. This is the number of digits to which you want to round the number argument.


Usage Notes

The ROUNDDOWN function will always round a number down toward zero to a given number of digits. Use the ROUND function is you require a function that uses standard rounding rules.

num_digits Notes
If num_digits is less than 0, the number argument will be rounded down to the left of the decimal point.

If num_digits is greater than 0, the number argument will be rounded down to the specified number of decimal places.

If num_digits is equal to 0, the number argument will be rounded down to the nearest integer.