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.