Difference between revisions of "Documentation/How Tos/Calc: ROUNDUP function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
|||
Line 8: | Line 8: | ||
: returns <tt>'''number'''</tt> rounded up (away from zero) to <tt>'''places'''</tt> decimal places. If <tt>'''places'''</tt> is omitted or zero, the function rounds up to an integer. If <tt>'''places'''</tt> is negative, the function rounds up to the next <tt>'''10'''</tt>, <tt>'''100'''</tt>, <tt>'''1000'''</tt>, etc. | : returns <tt>'''number'''</tt> rounded up (away from zero) to <tt>'''places'''</tt> decimal places. If <tt>'''places'''</tt> is omitted or zero, the function rounds up to an integer. If <tt>'''places'''</tt> is negative, the function rounds up to the next <tt>'''10'''</tt>, <tt>'''100'''</tt>, <tt>'''1000'''</tt>, etc. | ||
− | : This function rounds ''away from zero''. See | + | : This function rounds ''away from zero''. See [[Documentation/How_Tos/Calc: ROUNDDOWN function|ROUNDDOWN]] and [[Documentation/How_Tos/Calc: ROUND function|ROUND]] for alternatives. |
=== Example: === | === Example: === | ||
Line 33: | Line 33: | ||
* [[Documentation/How_Tos/Calc: ROUND function|ROUND]] | * [[Documentation/How_Tos/Calc: ROUND function|ROUND]] | ||
* [[Documentation/How_Tos/Calc: ROUNDDOWN function|ROUNDDOWN]]''' | * [[Documentation/How_Tos/Calc: ROUNDDOWN function|ROUNDDOWN]]''' | ||
− | |||
* [[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]] | ||
Line 39: | Line 38: | ||
* [[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:19, 25 February 2009
ROUNDUP
Rounds a number up, away from zero, to a certain precision.
Syntax:
ROUNDUP(number; places)
- returns number rounded up (away from zero) to places decimal places. If places is omitted or zero, the function rounds up to an integer. If places is negative, the function rounds up to the next 10, 100, 1000, etc.
Example:
ROUNDUP(1.1111; 2)
- returns 1.12
ROUNDUP(1.2345; 1)
- returns 1.3
ROUNDUP(45.67; 0)
- returns 46
ROUNDUP(-45.67)
- returns -46
ROUNDUP(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.