Quick Navigation
ROUND Function
Summary
The ROUND function precisely rounds any number to a specified number of decimal places or significant digits. It follows standard rounding rules where .5 and above rounds up, below .5 rounds down, making it essential for financial calculations, data presentation, and statistical analysis.
Syntax
ROUND(number, num_digits)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| number | Number |
Yes | The numeric value requiring rounding |
| num_digits | Number |
Yes | Precision level: positive=decimals, 0=whole number, negative=tens/hundreds/etc. |
Using the ROUND Function
ROUND is the go-to function for standard rounding in Excel. Use positive num_digits for decimal precision, 0 for nearest integer, and negative values to round to tens, hundreds, or thousands. Perfect for cleaning up calculation results before display or further processing.
Common ROUND Examples
Basic Decimal Rounding
=ROUND(2.15, 1)Rounds 2.15 to one decimal place using standard banker's rounding
Negative Number Rounding
=ROUND(-1.475, 2)Correctly rounds negative values away from zero
Rounding to Nearest Integer
=ROUND(21.5, 0)Rounds to closest whole number
Rounding Left of Decimal
=ROUND(626.3, -3)Rounds to nearest thousand (1000)
Frequently Asked Questions
Common Errors and Solutions
#VALUE! error
Cause: Non-numeric value in number argument
Solution: Ensure number contains valid numeric data
Unexpected rounding results
Cause: Banker's rounding on exactly .5 values
Solution: Use ROUNDUP or ROUNDDOWN for consistent directional rounding
Notes
- ROUND uses banker's rounding for exactly .5 cases
- Available in all Excel versions
- Rounds negative numbers away from zero
- Combines well with other math functions
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in:
Content last reviewed: December 11, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+