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.