SheetsdrillROUND
ROUND(value, [places]) rounds a number to the given number of decimal places, halves away from zero, so ROUND(2.345, 2) is 2.35 and ROUND(1234, -2) is 1200. ROUNDUP and ROUNDDOWN always move away from or toward zero, and MROUND rounds to the nearest multiple, such as 0.05.
Syntax
=ROUND(value, [places])| Part | What it is |
|---|---|
value | The number or formula to round. |
places | Optional, default 0. Decimal places to keep; negative rounds to tens, hundreds, thousands. |
Examples
=ROUND(2.567, 2)Result: 2.57
ROUND(2.5) gives 3: halves round away from zero.
=ROUND(B2/C2, 2)Result: Unit price to the cent, for example 3.33 for 10/3
=ROUNDUP(7.21, 0)Result: 8
Common mistakes
- Formatting a cell to two decimals only changes the display; later calculations still use the full value. Use ROUND when the stored number must change.
- ROUND(x, -1) rounds to the nearest 10, not to one decimal; positive places are decimals, negative places are powers of ten.
- Expecting bankers rounding: ROUND(2.5) is 3 and ROUND(-2.5) is -3 in Google Sheets.
Practice ROUND
These drills check your answer on live data, free, no account needed.
- Round the unit priceWork out the price per unit (invoice total divided by units) and round it to 2 decimal places. Answer in B3.
Questions
How do I round to the nearest whole number?
=ROUND(A2) or =ROUND(A2, 0). For always up use CEILING or ROUNDUP, for always down FLOOR or ROUNDDOWN.
How do I round to the nearest 1000?
=ROUND(A2, -3), or =MROUND(A2, 1000).
Related
- SUM and AVERAGEHow SUM and AVERAGE work in Google Sheets, with examples for a column total, average order value, share of total with locked references, and why you get 0.
- TEXTHow the TEXT function in Google Sheets turns a number or date into formatted text: month labels, currency, percentages and leading zeros, with common codes.
- SUMPRODUCTHow SUMPRODUCT in Google Sheets multiplies two ranges row by row and adds the results, and how it works as a conditional sum with OR logic, with examples.
- IFHow the IF function in Google Sheets returns one value when a condition is true and another when it is false, with examples for text, blanks and nested IFs.