Documentation/How Tos/Calc: ROUNDDOWN function

CALC FUNCTIONS

Mathematical Functions

< Previous Section

Next Section >

FUNCTIONS

Trigonometric

• Cos
• Sin
• Tan
• Cot
• Acos
• Acot
• Asin
• Atan
• Atan2
• Degrees
• Radians
• Pi

Hyperbolic

• Cosh
• Sinh
• Tanh
• Coth
• Acosh
• Acoth
• Asinh
• Atanh

Rounding and remainders

• Trunc
• Round
• Rounddown
• Roundup
• Ceiling
• Floor
• Even
• Odd
• Mround
• Int
• Quotient
• Mod

Logarithm/Powers

• Exp
• Power
• Log
• Ln
• Log10

Bessel functions

• Besseli
• Besselj
• Besselk
• Bessely

Miscellaneous

• Abs
• Combin
• Combina
• Convert
• Convert Add
• Countblank
• Countif
• Delta
• Erf
• Erfc
• Fact
• Factdouble
• Gcd
• Gcd Add
• Gestep
• Iseven
• Isodd
• Lcm
• Lcm Add
• Multinomial
• Product
• Rand
• Randbetween
• Seriessum
• Sign
• Sqrt
• Sqrtpi
• Subtotal
• Sum
• Sumif
• Sumsq

< Previous 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.

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

---

See Also

• INT
• TRUNC
• ROUND
• ROUNDUP
• CEILING
• FLOOR
• EVEN
• ODD
• MROUND
• Mathematical functions
• Functions listed alphabetically
• Functions listed by category