Math & Trig
Modern
ROUND
Rounds a number to a specified number of digits.
Available in All versions
Syntax
ROUND(number, num_digits)What it returns
The rounded number.
Arguments
| Argument | Required | Description |
|---|---|---|
number |
Yes | The number to round. |
num_digits |
Yes | The number of digits to round to (2 = two decimals, 0 = integer, -1 = nearest ten). |
Example
Before
3.14159
After
3.14
ROUND keeps only the number of decimals you ask for (here 2).
=ROUND(B2, 2)Important to know
num_digits > 0 rounds decimals; 0 rounds to integer; < 0 rounds left of the decimal point.
For always-up / always-down, use ROUNDUP / ROUNDDOWN.