ROUND
Rounds a number to a specified number of digits.
ROUND(number, num_digits)Arguments
numberThe number to roundnum_digitsNumber of decimal places (negative for left of decimal)
=ROUND(3.14159,2)Rounds to 2 decimal places
=ROUND(1234,-2)Rounds to nearest 100
=ROUND(A1,0)Rounds to nearest integer
- •Negative num_digits rounds to left of decimal point
- •Use ROUNDUP or ROUNDDOWN for specific direction
- •0.5 is rounded up
- •Confusing the sign of num_digits - a negative number rounds to the left of the decimal point, not the right
- •Using ROUND when the goal is really just to change the display format, which permanently discards precision from the stored value
- •Assuming two numbers that look equal after rounding will always compare as equal - tiny floating-point differences can still make them unequal
What's the difference between ROUND and just formatting cells to show fewer decimals?
Formatting only changes the display - the full unrounded number is still stored and used in later calculations. ROUND actually changes the stored value.
How do I round to the nearest 10 or 100?
Use a negative num_digits: ROUND(A1,-1) rounds to the nearest 10, ROUND(A1,-2) to the nearest 100.
Why do two numbers that look equal after rounding sometimes compare as unequal?
Floating-point precision - the underlying stored value can differ by a tiny fraction even when the rounded display matches. Round both sides before comparing if this matters.
Need to translate a formula using ROUND?
Use our translator to convert your complete formula