Difference between revisions of "Documentation/How Tos/Calc: ROUNDDOWN function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(→‎See also:)
m
 
(9 intermediate revisions by 5 users not shown)
Line 1: Line 1:
−
__NOTOC__
+
{{{DISPLAYTITLE:ROUNDDOWN function}}
 +
{{Documentation/CalcFunc MathematicalTOC
 +
|ShowPrevNext=block
 +
|PrevPage=Documentation/How_Tos/Calc:_ROUND_function
 +
|NextPage=Documentation/How_Tos/Calc:_ROUNDUP_function
 +
}}__NOTOC__
  
 
== ROUNDDOWN ==
 
== ROUNDDOWN ==
Line 8: Line 13:
 
: 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 '''[[Documentation/How_Tos/Calc: ROUNDUP function|ROUNDUP]]''' and '''[[Documentation/How_Tos/Calc: ROUND function|ROUND]]''' for alternatives.
+
: 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 23: Line 28:
 
: returns <tt>'''900'''</tt>
 
: returns <tt>'''900'''</tt>
  
−
If these examples do not seem to work, see '''Tools - Options - OpenOffice.org Calc - Calculate''' to check the display precision.  
+
If these examples do not seem to work, see {{menu|Tools|Options|OpenOffice Calc|Calculate}} to check the display precision.  
  
−
=== See also: ===
+
{{SeeAlso|EN|
−
'''[[Documentation/How_Tos/Calc: INT function|INT]]''',
+
* [[Documentation/How_Tos/Calc: INT function|INT]]
−
'''[[Documentation/How_Tos/Calc: TRUNC function|TRUNC]]''',
+
* [[Documentation/How_Tos/Calc: TRUNC function|TRUNC]]
−
'''[[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]]''',
+
* [[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: Functions listed alphabetically|Functions listed alphabetically]]
−
'''[[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]'''
+
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
−
 
+
[[Category: Documentation/Reference/Calc/Mathematical functions]]
−
[[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']],
+
−
[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]
+

Latest revision as of 14:39, 31 January 2024

{

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.
This function rounds towards zero. See ROUNDUP and ROUND for alternatives.

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


See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_ROUNDDOWN_function&oldid=259860"
Views
Personal tools
Navigation
Tools
In other languages