ROUND Function in Excel – Round off Values in Excel

ROUND Function in Excel, Round off the number to the specified decimal places.

Syntax of ROUND function in Excel

ROUND(number,num_digits)

number – The number to be rounded

num_digits – The number of decimal places to which the number has to be rounded off.

A positive num_digits value specifies the number of digits to the right of the decimal point.
if num_digits value of 0 specifies rounding to the nearest integer.
A negative num_digits value specifies the number of digits to the left of the decimal point.

Example of ROUND Function in Excel

FORMULA

ROUND Function in Excel 1

Row number 2 & 3 Round off to 1 and 2 decimal places respectively
Row number 4 Round off to nearest integer
Row number 5 Round off to nearest 10
Row number 6 Round off to nearest 100

So the result will be

Result

ROUND Function in Excel 2

Related Posts: