Spread 8.0 Documentation
ISODD
Support Options
Formula Reference > Built-In Functions > ISODD

Glossary Item Box

ISODD


Name

Is number odd

Description

Tests if a number is odd.

Syntax

ISODD(value)

Remarks

If the number specified by the value argument is odd, then the function returns 1 (True). If the number specified by the value argument is even, then the function returns 0 (False).

Specify a numeric value, expression, or cell reference for the value argument.

See also ISEVEN.

Data Type

Accepts any data. Returns numeric (boolean) data. For more information, see Data Type for Each Cell Type.

Example

ISODD(R1C2)
ISODD(B3)
ISODD(12) = 0 (False)
ISODD(2.5) = 0 (False)
ISODD(3.4) = 1 (True)

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.