OpenOffice3.org Calc 3. Information Functions

ISODD_ADD(value) Function

Returns a logical value. Returns TRUE if the argument contains an odd number. On the other hand, if the argument contains an even number, the function returns FALSE. The argument “value” contains an integer or a reference to a cell containing a number. If the argument is a number with a decimal part, the result calculated by ignoring the decimal part. This funtion is provide for compatibility with international standards, for example, with Microsoft Excel. Consider the following examples:

=ISODD_ADD(12) Returns FALSE, Indicates that the number is not odd.
=ISODD_ADD(33) Returns TRUE, the argument is an odd number.
=ISODD_ADD(15,6) Returns TRUE. The argument is an odd number. The function ignores the decimal part to calculate the result.

 

Back to the list of information functions