ROUND Function in Excel
Beginner
Rounds a number to a specified number of digits.
Syntax
=ROUND(number, num_digits)Example
Use Case
Round prices to 2 decimal places for display.
Common Errors to Avoid
- Positive num_digits rounds decimals, negative rounds to left of decimal
- Rounds to nearest value - use ROUNDUP or ROUNDDOWN for directional rounding
- Doesn't format display - cell formatting is separate
Pro Tips
Use num_digits=2 for currency, 0 for whole numbers, -1 for nearest 10, -2 for nearest 100. ROUND changes the actual value, not just display. For banker's rounding, use MROUND. Combine with SUM to avoid rounding errors in calculations.
Need help with this formula?
Our AI Formula Generator can write this for you instantly.
Try AI Formula Generator →