Google Sheets function
ROUND function in Google Sheets
ROUND in Google Sheets rounds a number to a chosen number of decimal places. Positive places keep digits after the decimal, zero rounds to an integer, and negative places round to the left of the decimal. Use ROUND when calculations need a controlled numeric precision.
Source: Google Docs Editors HelpLast verified Nov 5, 2026
Syntax
=ROUND(value, [places])Arguments
| Argument | Required | What it means |
|---|---|---|
value | Yes | The number to round. |
places | No | The number of decimal places to keep. The default is 0. |
Examples
Round a unit price
| A | B | |
|---|---|---|
| 1 | Item | Unit price |
| 2 | Cable | 18.376 |
=ROUND(B2,2)Result: 18.38
The third decimal digit is 6, so the second decimal digit rounds up.
Common mistakes
Formatting a cell and assuming its stored value was rounded.
Use ROUND when later calculations must use the rounded number.
Using a positive places value to round to tens or hundreds.
Use a negative places value to round left of the decimal point.