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
- 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