These docs are for v1.0. Click to read the latest docs for v1.2.

ROUND

Rounds a number to specified number of digits.

Syntax

=ROUND(value, digits)

Arguments

ArgumentTypeDescription
valueNumberThe value to round
digitsNumber(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