How it works.
ROUND rounds a numeric value to a specified number of decimal places. If num_digits is 0, it rounds to the nearest whole integer. If num_digits is negative, it rounds to the left of the decimal point (e.g. tens or hundreds).
💡 In simple terms.
Rounds a decimal number to a specific number of decimal places (like rounding 19.9567 to 19.96).
Analogy
"Think of this like checking your height. If you are 138.6 cm, you might round it to the nearest whole number, which is 139 cm."
Syntax guide.
=ROUND(number, num_digits)
Parameters
numberRequired
The number you want to round.
num_digitsRequired
The number of digits to which you want to round the number.
Interactive formula builder.
Fill in the input arguments below to construct your custom formula string. Copy it directly to paste into your Excel spreadsheets.
Generated Output
Best Practices
- To always round up (away from zero), use ROUNDUP. To always round down (toward zero), use ROUNDDOWN.
- To round to a multiple of a specific number (like rounding to the nearest 0.05), use MROUND.
Common Gotchas
- Rounding values can introduce small math differences when summing rounded numbers vs summing exact values.