OpenOffice3.org Calc 3. Mathematical Functions
ROUNDDOWN(number; count) Function
Rounds the argument “Number” with the
accuracy determined by the argument “count”. The approximtaion of the value is
always close to zero. Therefore, if the number to be rounded is positive,
returns a number less than or equal to that value. On the other hand, if the
number to round is negative, returns a number greater than or equal to that
value. The argument “number” can take any numerical value. Contains the number
to round. The argument “count” is optional, contains an integer numerical value.
This argument indicates the number of decimal digits that shows the result. If
“count” is zero, making the approach to the nearest integer. If the argument
“count” is a negative number, the function returns an integer. If “count” is a
negative number, the rounding is the nearest 10, 100, 1000, etc. Look at the
examples to better understand the function.
=ROUNDDOWN(0,96495;3) Returns 0,964.
=ROUNDDOWN(-6,32954;2) Returns -6,32.
=ROUNDDOWN(6543,545;-1) Returns 6540.
=ROUNDDOWN(456234,111;-2) Returns 456200.
=ROUNDDOWN(-345699,234;-2) Returns -345600.