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