OpenOffice3.org Calc 3. Mathematical Functions

ROUND(number; count) Function

Returns a numeric value. Rounds the number indicated by the argument “number”, leaving the number of the decimal places specified by the argument “count”. The argument “number” contains a numerical value or a reference to cell. Contains the number you want rounded. The argument “count” is optional, contains an integer numeric value or a reference to a cell containing an integer. Indicates the number of decimal places to round number. If “count” is a negative number, the function rounds the number to integer 10, 100, 1000, etc nearest. If you omit the “count” or “count” is 0, the function rounds the number to the nearest integer. The following examples help to undertand the function.

=ROUND(3,4545;2) Returns 3,45. Rounds the number to two decimal places.
=ROUND(12,982;2) Returns 12,98. Rounds the number to two decimal places.
=ROUND(12,889;0) Returns 13. Rounds the number to the nearest integer.
=ROUND(14262,933;-1) Returns 14260.
=ROUND(14262,14;-2) Returns 14300.
=ROUND(-13,223888) Returns -13, Omit the argument “count”, Round the number to the nearest integer.

Back to the list of mathematical functions