Round

This example illustrates three functions to round numbers in Excel. The ROUND, ROUNDUP and ROUNDDOWN function.

1. Round a number to two decimal places.

Round to Two Decimal Places

2. Round a number to one decimal place.

Round to One Decimal Place

3. Round a number to the nearest integer.

Round to Nearest Integer

4. Round a number up.

Round Up

5. Round a number down.

Round Down

Did you find this information helpful? Please vote for us.

Go to Top: Round | Go to Next Example: Random Numbers

excel