12 April 2014: The OpenOffice Wiki is not, and never was, affected by the heartbleed bug. Users' passwords are safe and wiki users do not need take any actions.

Documentation/How Tos/Calc: ROUND function

From Apache OpenOffice Wiki
Jump to: navigation, search


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.
This function rounds to the nearest number. See ROUNDDOWN and ROUNDUP for alternatives.

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.org Calc - Calculate to check the display precision.


See Also

Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_ROUND_function&oldid=225714"
Views
Personal tools
Navigation
Print/export
Tools