Round Excel Numbers

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

Round Function

The ROUND function rounds the number to a specific number of digits.

The ROUND function has two arguments. The first argument is for the number that you want to round. The second argument is for the number of digits to which you want to round the number.

Examples:

- If the number of digits is greater than 0, Excel rounds the number to the specified number of decimal places.

- If the number of digits equals 0, Excel rounds the number to the nearest Integer.

- If the number of digits is less than 0, Excel rounds the number to the left of the decimal point.

Roundup & Rounddown Function

The ROUNDUP function always rounds a number up. The ROUNDDOWN function always rounds a number down. It's as easy as it sounds.

Examples:

Did you like this free Excel tutorial? Show your appreciation, vote for us.

Follow

Thank you very much! We've got many more free Excel tutorials for you. Read on, learn, and enjoy!

Go to Top: Round Excel Numbers    |    Go to Next Tutorial: Excel Transpose