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