OpenOffice3.org Calc 3. Mathematical Functions

Función FLOOR(Number; Significance; Mode)

Returns the numeric value that is closer to the argument “Number” and that is a multiple of the argument “Significance”. The argument “number” contains a numeric value or a reference to a cell containing a number. Indicates the amount to approximate or rounded. The argument “Significance” contains a numeric value or a reference to a cell that has a number. The function returns the number that is a multiple of the argument “Significance”. The argument “Mode” is optional, contains an integer that determines how the function calculates the result. The argument “Mode” affects the result only when the first two arguments are negative numbers. If the arguments “Number” and “Significance” are positive numbers, the function returns a value less that or equal, closer to the first argument, which is a multiple of the argument “Significance”. In this case, no matter what value to take the argument “Mode”.
On the other hand, if the two arguments “number” and “significance” are negative values, in addition, if the argument “Mode” is zero or omitted, the function returns a number less than or equal, closer to the first argument,which is a multiple of the argument “Significance”.
The third possibility that can happen is this: if the first two arguments are negative numbers, in adittion, if the argument “Mode” is a number different from zero the function returns a number greater than or equal, closest to the argument “Number” which is a multiple of the argument “Significance”.

=FLOOR(35;6;1) Returns 30. The return value is the lowest number and closer to 35, which is multiple 6. Note that 30 is a multiple of 6.
=FLOOR(-47;-6;0) Returns -48. The return value is lower and closer to -47, that is a multiple of -6.
=FLOOR(-47;-6;1) Returns -42. In this case, the function returns the greatest number and colser to -47, that is a multiple of -6. The result varies with the argument “Mode”.
=FLOOR(30;-2;1) Return the error value Err:502. The first two arguments have diferent signs, the first argument is positive, while the second is negative.

Back to the list of mathematical functions