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.

Back to the list of mathematical functions