Difference between revisions of "Documentation/How Tos/Calc: ROUND function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Bot: Adding Category: Documentation) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
Line 38: | Line 38: | ||
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
− | [[Category: Documentation]] | + | [[Category: Documentation/Reference/Calc]] |
Revision as of 09:43, 24 November 2009
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.org Calc - Calculate to check the display precision.