OpenOffice3.org Calc 3. Information Functions
ISEVEN_ADD(Number) Function
Returns an integer numeric value. If the
argument “Number” contains an even number, the function returns 1. If the
argument contains an odd number, the function returns 0. The argument “Number”
contains an integer or reference to a cell with an integer. If the argument
contains a number with decimal part, the result calculated by ignoring the
decimal part. For example:
=ISEVEN_ADD(25 ) Returns 0. Indicates that the argument is an odd number.
=ISEVEN_ADD(34 ) Returns 1. The argument is an even number.
=ISEVEN_ADD(4,33) Returns 1. The number without decimal part is even number.
=ISEVEN_ADD(4 + 2) Returns 1. The result of sum is an even number.