Difference between revisions of "Documentation/How Tos/Calc: ROUNDDOWN 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 down (towards zero) to <tt>'''places'''</tt> decimal places. If <tt>'''places'''</tt> is omitted or zero, the function rounds down to an integer. If <tt>'''places'''</tt> is negative, the function rounds down to the next <tt>'''10'''</tt>, <tt>'''100'''</tt>, <tt>'''1000'''</tt>, etc. | : returns <tt>'''number'''</tt> rounded down (towards zero) to <tt>'''places'''</tt> decimal places. If <tt>'''places'''</tt> is omitted or zero, the function rounds down to an integer. If <tt>'''places'''</tt> is negative, the function rounds down to the next <tt>'''10'''</tt>, <tt>'''100'''</tt>, <tt>'''1000'''</tt>, etc. | ||
− | : This function rounds ''towards zero''. See | + | : This function rounds ''towards zero''. See [[Documentation/How_Tos/Calc: ROUNDUP function|ROUNDUP]] and [[Documentation/How_Tos/Calc: ROUND function|ROUND]] for alternatives. |
=== Example: === | === Example: === | ||
Line 30: | Line 30: | ||
* [[Documentation/How_Tos/Calc: ROUND function|ROUND]] | * [[Documentation/How_Tos/Calc: ROUND function|ROUND]] | ||
* [[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]] | ||
Line 36: | Line 35: | ||
* [[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
ROUNDDOWN
Rounds a number down, toward zero, to a certain precision.
Syntax:
ROUNDDOWN(number; places)
- returns number rounded down (towards zero) to places decimal places. If places is omitted or zero, the function rounds down to an integer. If places is negative, the function rounds down to the next 10, 100, 1000, etc.
Example:
ROUNDDOWN(1.234; 2)
- returns 1.23
ROUNDDOWN(45.67; 0)
- returns 45
ROUNDDOWN(-45.67)
- returns -45
ROUNDDOWN(987.65; -2)
- returns 900
If these examples do not seem to work, see Tools - Options - OpenOffice.org Calc - Calculate to check the display precision.