Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Rounds a number to the specified number of digits.
Syntax
ROUND(<number>, <num_digits>)
Parameters
| Term | Definition |
|---|---|
number |
The number you want to round. |
num_digits |
The number of digits to which you want to round. A negative value rounds digits to the left of the decimal point; a value of zero rounds to the nearest integer. |
Return value
A decimal number.
Remarks
If
num_digitsis greater than 0 (zero), then number is rounded to the specified number of decimal places.If
num_digitsis 0, the number is rounded to the nearest integer.If
num_digitsis less than 0, the number is rounded to the left of the decimal point.Ties are broken by rounding half away from zero (also known as commercial rounding). | Examples | Result | | --- | --- | |
= ROUND(1.15, 1)| 1.2 | |= ROUND(-1.15, 1)| -1.2 |Related functions
- To always round up (away from zero), use the ROUNDUP function.
- To always round down (toward zero), use the ROUNDDOWN function.
- To round a number to a specific multiple (for example, to round to the nearest multiple of 0.5), use the MROUND function.
- Use the functions TRUNC and INT to obtain the integer portion of the number.
Example 1
The following formula rounds 2.15 up, to one decimal place. The expected result is 2.2.
= ROUND(2.15,1)
Example 2
The following formula rounds 21.5 to one decimal place to the left of the decimal point. The expected result is 20.
= ROUND(21.5,-1)