The ROUND, ROUNDUP and ROUNDDOWN function in Excel

The ROUND, ROUNDUP and ROUNDDOWN function in MS Excel

The ROUND function is used to round the fraction values into a rounded figure to a specified number of digits. This function is very important and has many implementation scenarios.

There are three functions to round numbers in MS Excel. The ROUND, ROUNDUP and ROUNDDOWN function.

ROUND

Round a number to two decimal places.

In the example above, 114.7261 get rounded up to 114.73.

Round a number to one decimal place.

Round a number to the nearest integer.

Round a number to the nearest 10.

In the above example, the integer value is further rounded to the nearest 10.

Round a number to the nearest 100.

In the above example, the integer value is further rounded to the nearest 100.

ROUNDUP

The ROUNDUP function is used to rounds a number up regardless if it is near to 0. In the example below, you will observe that the value in cell A1 is rounded up to 1 fractional digit.

ROUNDDOWN

The ROUNDDOWN function is used to rounds a number downward regardless if it is near to 10. In the example below, you will observe that the value in cell A1 is rounded down to its integer value.