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.
 

Back to the list of information functions