OpenOffice3.org Calc 3. Mathematical Functions
EVEN(Number) Function
Returns an integer. Returns the nearest
even number to the number indicated by the argument “Number”. If the argument is
a positive number, the function returns a number greater, closer to “Number”. If
the argument is a negative number, the function returns a number less and closer
to the argument “Number”. For example:
=EVEN(3,5) Returns 4. Is the number greater and closer to 3,5. In this case the
argument is positive.
=EVEN(-3,5) Returns -4. Is the number less and closer to -3,5. In this case, the
argument is a negative number.
=EVEN(6) Returns 6. The argument is a number, returns the same number.
=EVEN(-6) Returns -6. Again, the argument is a number, returns the same number.