Rounds a number to the specified number of digits.
|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.|
A decimal number.
If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.
If num_digits is 0, the number is rounded to the nearest integer.
If num_digits is less than 0, the number is rounded to the left of the decimal point.
- 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.
The following formula rounds 2.15 up, to one decimal place. The expected result is 2.2.
The following formula rounds 21.5 to one decimal place to the left of the decimal point. The expected result is 20.