ROUND function

Applies To

„SharePoint Server“ prenumeruojamas leidimas „SharePoint Server 2019“ „SharePoint Server 2016“ „SharePoint Server 2013“ „SharePoint Server 2013 Enterprise“ „SharePoint“, esantis „Microsoft 365“ SharePoint Foundation 2010 „SharePoint Server 2010“ „SharePoint“, esantis „Microsoft 365 Small Business“ Windows SharePoint Services 3.0

Rounds a number to a specified number of digits.

Syntax

ROUND(number,num_digits)

Number Is the number you want to round.

Num_digits Specifies the number of digits to which you want to round the number.

Remarks

If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.
If num_digits is 0, then number is rounded to the nearest integer.
If num_digits is less than 0, then number is rounded to the left of the decimal point.

Examples

Formula	Description (Result)
=ROUND(2.15, 1)	Rounds 2.15 to one decimal place (2.2)
=ROUND(2.149, 1)	Rounds 2.149 to one decimal place (2.1)
=ROUND(-1.475, 2)	Rounds -1.475 to two decimal places (-1.48)
=ROUND(21.5, -1)	Rounds 21.5 to one decimal place to the left of the decimal point (20)