ROUND
Rounds a number to specified number of digits.
Syntax
=ROUND(value, digits)
Arguments
| Argument | Type | Description |
|---|---|---|
| value | Number | The value to round |
| digits | Number | (Optional) The number of digits to round the value, defaults to 0 |
Examples
=ROUND(3.14159, 3)→3.142
Rounds the value 3.14159 to 3 digits
=ROUND(3.14159, 2)→3.14
Rounds the value 3.14159 to 2 digits
=ROUND(-2.718)→-3
Rounds the value -2.718 to 0 digits
=ROUND(5, 3)→5
Rounds the value 5 to 3 digits
Updated 10 months ago