ROUNDDOWN
Rounds a number down, toward zero.
Syntax
ROUNDDOWN(<number>, <num_digits>)
Parameters
| Term | Definition |
|---|---|
| number | A real number that you want rounded down. |
| num_digits | The number of digits to which you want to round. Negative rounds to the left of the decimal point; zero to the nearest integer. |
Return value
A decimal number.
Remarks
If num_digits is greater than 0 (zero), then the value in number is rounded down to the specified number of decimal places.
If num_digits is 0, then the value in number is rounded down to the nearest integer.
If num_digits is less than 0, then the value in number is rounded down to the left of the decimal point.
ROUNDDOWN behaves like ROUND, except that it always rounds a number down. The INT function also rounds down, but with INT the result is always an integer, whereas with ROUNDDOWN you can control the precision of the result.
Example 1
The following example rounds 3.14159 down to three decimal places. The expected result is 3.141.
= ROUNDDOWN(3.14159,3)
Example 2
The following example rounds the value of 31415.92654 down to 2 decimal places to the left of the decimal. The expected result is 31400.
= ROUNDDOWN(31415.92654, -2)
Related content
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for