Difference between revisions of "Documentation/How Tos/Calc: ROUNDDOWN function"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (Talk | contribs) |
Javier Lopez (Talk | contribs) |
||
Line 3: | Line 3: | ||
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div> | |booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div> | ||
|ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Mathematical_functions|<div style="font-size: 140%;">Mathematical Functions]] | |ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Mathematical_functions|<div style="font-size: 140%;">Mathematical Functions]] | ||
− | |ShowNextPage=block|NextPage=Documentation/How_Tos/Calc: | + | |ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_ROUNDUP_function |
− | |ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc: | + | |ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_ROUND_function |
|ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Logical_functions | |ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Logical_functions | ||
|ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Number_Conversion_functions | |ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Number_Conversion_functions |
Revision as of 07:43, 1 June 2013
CALC FUNCTIONS
- Mathematical FunctionsTrigonometric
- CosSinTanCotAcosAcotAsinAtanAtan2DegreesRadiansPiHyperbolic
- CoshSinhTanhCothAcoshAcothAsinhAtanhRounding and remainders
- TruncRoundRounddownRoundupCeilingFloorEvenOddMroundIntQuotientModLogarithm/Powers
- ExpPowerLogLnLog10Bessel functions
- BesseliBesseljBesselkBesselyMiscellaneous
- AbsCombinCombinaConvertConvert AddCountblankCountifDeltaErfErfcFactFactdoubleGcdGcd AddGestepIsevenIsoddLcmLcm AddMultinomialProductRandRandbetweenSeriessumSignSqrtSqrtpiSubtotal
Contents
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.
Template:Documentation/SeeAlso
-