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.

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 one decimal place

Round a number to the nearest integer.

Round a number to the nearest integer

Round a number to the nearest 10.

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.

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.

ROUNDUP

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.

 ROUNDDOWN

Search

Shortcodes Ultimate

 
Follow Us
 
BGP