This topic has not yet been rated - Rate this topic

ROUND Function

SQL Server 2012

Rounds a number to the specified number of digits.


ROUND(<number>, <num_digits>)

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.

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.

You can 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.

=ROUND(2.15,1)

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)

ROUND Function

ROUNDDOWN Function

MROUND Function

INT Function

TRUNC Function

Math and Trig Functions (DAX)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions