ROUND function
From Apache OpenOffice Wiki
< Documentation | How Tos
Trigonometric
Hyperbolic
Rounding and remainders
Logarithm/Powers
Bessel functions
Miscellaneous
ROUND
Rounds a number to a certain precision.
Syntax:
ROUND(number; places)
- returns number rounded to places decimal places. If places is omitted or zero, the function rounds to the nearest integer. If places is negative, the function rounds to the nearest 10, 100, 1000, etc.
Example:
ROUND(2.348; 2)
- returns 2.35
ROUND(2.348; 0)
- returns 2
ROUND(2.5)
- returns 3
ROUND(987.65; -2)
- returns 1000
If these examples do not seem to work, see Tools → Options → OpenOffice Calc → Calculate to check the display precision.
See Also