नोट
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप साइन इन करने या निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
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_digitsis greater than 0 (zero), then the value innumberis rounded down to the specified number of decimal places.If
num_digitsis 0, then the value innumberis rounded down to the nearest integer.If
num_digitsis less than 0, then the value innumberis 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)