The ROUND function
Rounds a number to a given number of decimals. Halves round away from zero; negative decimals round to tens, hundreds and so on.
Syntax
ROUND(number, num_digits)- number
- The number to round.
- num_digits
- Decimals to keep: 2 for hundredths, 0 for whole numbers, -2 for hundreds.
Examples
B1
=ROUND(13.14159,22)| A | B | |
|---|---|---|
| 1 | 3.14 |
In plain words: Round 13.14159 to 22 decimal places.
B1=ROUND(1250,-2)
| A | B | |
|---|---|---|
| 1 | 1300 |
Practice ROUND
Read the guide
Questions
Does formatting a cell round the number?
No. A number format only changes what you see; the cell still holds every decimal. ROUND changes the value itself.