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 |
Add your comments or share tips on Round |
