Rounds a number down, toward zero.
Syntax
ROUNDDOWN(number, num_digits)Argumente
numbererforderlich
The real number that you want to round down.
num_digitserforderlich
The number of digits to which you want to round the number.
The ROUNDDOWN function behaves like ROUND, except that it always rounds a number down. If num_digits is greater than 0, the number is rounded down to the specified number of decimal places; if it is 0 or negative, it rounds toward zero to the left of the decimal point.
=ROUNDDOWN(3.14159, 3)→3.141Rounds 3.14159 down to three decimal places.
=ROUNDDOWN(314.159, -1)→310Rounds 314.159 down to the nearest ten.
Select the cell
Click on the cell where you want the result to appear.
Enter the formula
Type =ROUNDDOWN( followed by the number or cell reference, a comma, the number of digits, and a closing parenthesis.
ROUND rounds to the nearest value (up or down), while ROUNDDOWN always rounds toward zero.