Rounding

Rounding#

ROUND() rounds a numeric value to a specified number of decimal places.

Formula arguments use semicolons.

Function#

=ROUND(VALUE)
=ROUND(VALUE;DECIMAL_PLACES)

Pipe modifier form#

ROUND can also be used as a pipe modifier.

The pipe modifier rounds the value produced by the expression on its left.

=VALUE | ROUND
=VALUE | ROUND()
=VALUE | ROUND(DIGITS)

Invalid values#

ROUND() returns #VALUE! when:

the value is not numeric
the digit count is not an integer
too many arguments are provided

Examples:

=ROUND(Active)
=ROUND(1.234; 1.5)
=ROUND(1; 2; 3)

Notes#

ROUND() uses spreadsheet-style half-up rounding.

This means:

=ROUND(2.5)   -> 3
=ROUND(-2.5)  -> -3

Example - Using ROUND#

Value	Function	Render
6.7	`=ROUND(A2)`	7
6.7	`=ROUND(A3;1)`	6.7
6.7	`=ROUND(A4;2)`	6.7
3.14159	`=ROUND(A5)`	3
3.14159	`=ROUND(A6;1)`	3.1
3.14159	`=ROUND(A7;2)`	3.14
3.14159	`=ROUND(A8;3)`	3.142
3.14159	`=ROUND(A9;4)`	3.1416
3.14159	`=ROUND(A10;5)`	3.14159

Example - Using ROUND Code#

.. rcsv-table::
    :header-rows: 1

     Value,Function,=Render | RIGHT
     =6.7 | CENTER,=``=ROUND(A2)``,=ROUND(A2) | RIGHT
     =6.7 | CENTER,=``=ROUND(A3;1)``,=ROUND(A3;1) | RIGHT
     =6.7 | CENTER,=``=ROUND(A4;2)``,=ROUND(A4;2) | RIGHT
     =3.14159 | CENTER,=``=ROUND(A5)``,=ROUND(A5) | RIGHT
     =3.14159 | CENTER,=``=ROUND(A6;1)``,=ROUND(A6;1) | RIGHT
     =3.14159 | CENTER,=``=ROUND(A7;2)``,=ROUND(A7;2) | RIGHT
     =3.14159 | CENTER,=``=ROUND(A8;3)``,=ROUND(A8;3) | RIGHT
     =3.14159 | CENTER,=``=ROUND(A9;4)``,=ROUND(A9;4) | RIGHT
     =3.14159 | CENTER,=``=ROUND(A10;5)``,=ROUND(A10;5) | RIGHT

Example - Using ROUND Pipe Modifier#

Value	Function	Render
6.7	`=A2 \| ROUND()`	7
6.7	`=A3 \| ROUND(1)`	6.7
6.7	`=A4 \| ROUND(2)`	6.7
3.14159	`=A5 \| ROUND()`	3
3.14159	`=A6 \| ROUND(1)`	3.1
3.14159	`=A7 \| ROUND(2)`	3.14
3.14159	`=A8 \| ROUND(3)`	3.142
3.14159	`=A9 \| ROUND(4)`	3.1416
3.14159	`=A10 \| ROUND(5)`	3.14159