Difference between revisions of "Documentation/How Tos/Calc: ROUND function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
|||
| Line 29: | Line 29: | ||
* [[Documentation/How_Tos/Calc: TRUNC function|TRUNC]] | * [[Documentation/How_Tos/Calc: TRUNC function|TRUNC]] | ||
* [[Documentation/How_Tos/Calc: ROUNDDOWN function|ROUNDDOWN]] | * [[Documentation/How_Tos/Calc: ROUNDDOWN function|ROUNDDOWN]] | ||
| − | * [[Documentation/How_Tos/Calc: ROUNDUP function|ROUNDUP]] | + | * [[Documentation/How_Tos/Calc: ROUNDUP function|ROUNDUP]] |
* [[Documentation/How_Tos/Calc: CEILING function|CEILING]] | * [[Documentation/How_Tos/Calc: CEILING function|CEILING]] | ||
* [[Documentation/How_Tos/Calc: FLOOR function|FLOOR]] | * [[Documentation/How_Tos/Calc: FLOOR function|FLOOR]] | ||
* [[Documentation/How_Tos/Calc: EVEN function|EVEN]] | * [[Documentation/How_Tos/Calc: EVEN function|EVEN]] | ||
* [[Documentation/How_Tos/Calc: ODD function|ODD]] | * [[Documentation/How_Tos/Calc: ODD function|ODD]] | ||
| − | * [[Documentation/How_Tos/Calc: MROUND function|MROUND]] | + | * [[Documentation/How_Tos/Calc: MROUND function|MROUND]] |
| − | * [[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]] | + | * [[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]] |
* [[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]]}} | ||
Revision as of 14:36, 26 February 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.
