The Excel ROUND function rounds a number to a specified number of digits.
Syntax
=ROUND(Number
, Number of digits
)
Argument | Argument description | |
---|---|---|
1 | Number | The number to round. |
2 | Number of digits | The 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
:
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
There are a lot! So many that we’ve written an article on them.
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.