Home/Formulas/Math/ROUND
Matheasy

ROUND()

Rounds a number to a certain number of decimal places.

Syntax
fx
=ROUND(value, [places])
Try it
F2
→
24,900
Sample data · sales.csv
ABCD
1CompanyRegionQuarterRevenue
2Acme CoWestQ118,400
3Acme CoWestQ222,100
4Acme CoWestQ331,700
5Acme CoWestQ448,200
6GlobexEastQ114,200
7GlobexEastQ219,800
8GlobexEastQ323,400

Common pitfalls

  • Banker's rounding is NOT used. ROUND(0.5, 0) rounds to 1 (away from zero), unlike some statistical libraries.
  • Negative places rounds to the LEFT of the decimal: ROUND(1234, -2) returns 1200. Useful for bucket math.
Related formulas
ROUNDUP()
Rounds a number up to the next integer or decimal place, away from zero.
Used by
ROUNDUP()
Rounds a number up to the next integer or decimal place, away from zero.
MOD()
Returns the remainder after dividing one number by another. MOD(10, 3) = 1.
More Math formulas →Keyboard shortcuts for Sheets →