Free ROUND Formula Generator — Round Numbers in Excel & Sheets
Rounds a number to a specified number of digits.
Common Errors & Fixes
Unexpected rounding result
Causes:- Display formatting shows fewer decimals but the actual value is not rounded.
- Negative num_digits rounds to the left of the decimal, changing magnitude significantly.
Fixes:- Use ROUND in the formula, not just cell formatting.
- Check the num_digits value — positive for decimal places, negative for tens/hundreds.
Frequently Asked Questions
What is the difference between ROUND, ROUNDUP, and ROUNDDOWN?
ROUND rounds to the nearest value (away from zero at .5). ROUNDUP always rounds up (away from zero). ROUNDDOWN always rounds down (toward zero).
Can I round to the left of the decimal point?
Yes. Use negative num_digits: -1 rounds to tens, -2 to hundreds, -3 to thousands. Example: =ROUND(1234, -2) returns 1200.
Does Excel use bankers rounding?
No. Excel ROUND uses standard rounding (0.5 always rounds up). For bankers rounding (round to even), use a custom VBA function.
Want to become an Excel Pro?
Stop searching for formulas. Master Excel in 30 days with this top-rated course.
Learn More