Syntax
ROUND(number, num_digits)
| Parameter | Description |
|---|---|
| number | Parameter of the ROUND function. |
| num_digits | Parameter of the ROUND function. |
Examples
Round to 2 decimal places (currency)
Formula
=ROUND(A2*0.0825, 2)
Returns: 8.25 — rounds the tax calculation to exactly 2 decimal places
Round to nearest whole number
Formula
=ROUND(3.7, 0)
Returns: 4 — rounds 3.7 to the nearest integer
Round to nearest hundred
Formula
=ROUND(1234, -2)
Returns: 1200 — negative decimal places round to the left of the decimal point
Common Errors
#VALUE!
The first argument is text, not a number. Ensure the cell contains a numeric value or use VALUE() to convert.
Tips
ROUND vs ROUNDUP vs ROUNDDOWN
ROUND uses standard rounding. ROUNDUP always rounds away from zero. ROUNDDOWN always rounds toward zero (like truncation).
Financial precision
Always ROUND currency calculations: =ROUND(price*quantity*tax_rate, 2). Floating-point math can produce results like 10.005000001.
Negative decimal places
Use -1 to round to nearest 10, -2 for nearest 100, -3 for nearest 1000. Useful for budgets and estimates.
Try ROUND in Viztab
Import your data and use ROUND with 370+ other formulas. No signup required.
Open Viztab