Using the Excel ROUNDDOWN Function
SummaryThe 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)
The number argument is required in the ROUNDDOWN function and is the number that you want to round down.
The num_digits argument is also required. This is the number of digits to which you want to round the number argument.
Usage NotesThe 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.
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.