ROUNDDOWN function
From Apache OpenOffice Wiki
< Documentation | How Tos
{
Trigonometric
Hyperbolic
Rounding and remainders
Logarithm/Powers
Bessel functions
Miscellaneous
< {{#switch:Previous Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} | {{#switch:Next Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} > |
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 {{#if: Tools |Tools}}{{#if: Options | → Options}}{{#if: OpenOffice Calc | → OpenOffice Calc}}{{#if: Calculate | → Calculate}}{{#if: | → {{{5}}}}}{{#if: | → {{{6}}}}}{{#if: | → {{{7}}}}}{{#if: | → {{{8}}}}}{{#if: | → {{{9}}}}}{{#if: | → {{{10}}}}} to check the display precision.
{{#switch:EN
| RU = Смотрите также:
| UA = Дивіться також:
| EN = See Also
| PT = Ver também
| #default = See Also
}}