In Excel, the Round function returns a number rounded to a specified number of digits.
The syntax for the Round function is:
Round( number, digits)
number is the number to round.
digits is the number of digits to round the number to.
Examples:
Based on this table:
|
|
A |
|
1 |
Volume |
|
2 |
10 |
|
3 |
21.22 |
|
4 |
34 |
|
5 |
565.655 |
|
6 |
56 |
|
=Round(A3, 0) |
would return 21 |
|
=Round(A3, 1) |
would return 21.2 |
|
=Round(A3, -1) |
would return 20 |
|
=Round(55.1, -1) |
would return 60 |
|
=Round(-23.67, 1) |
would return -23.7 |
Round – Excel Function