Round

The Excel ROUND function rounds a number to a specified number of digits.

Syntax

=ROUND(Number, Number of digits)

Argument Argument description
1NumberThe number to round.
2Number of digitsThe number of digits to round to.

Use 0 to round to a whole number. Positive values will result in a number with that many decimal places. Negative values will round to the nearest 10 (using -1), 100 (using -2), etc.

Example: Simple Excel Round examples

The round function can be used in multiple ways. It can round to whole values, a specific number of digits, or to a specific number of 0’s. It all depends on the value of the Number of digits argument.

The fastest way to see the differences is by looking at a few examples. So here are some examples for different values of Number of digits:

Spreadsheet editor

Note: More rounding

The ROUND function may not always be the function that you need for the type of rounding that you’re looking for.

For example, you might want to round up or down. Or you may want to round to a specific multiple. And there are at least 5 other different types of rounding in Excel.

Since there’s so many, we’ve written an article on all the different rounding functions in Excel.

Questions

What other Round functions are there?

There are a lot! So many that we’ve written an article on them.

When is a value rounded up? And when is it rounded down?

All numbers ending in 5-9 are rounded up. Numbers ending in 1-4 are rounded down. And if a number ends in 0, it doesn’t need to be rounded.

Drawbacks

The biggest drawback of Excel’s Round function has to be that there are so many rounding functions. It’s difficult to keep track of what each one does.