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

previous-small ROUND Function in Excel                                                                                                                next_small ROUND Function in Excel