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

Glossary Item Box

ISEVEN


Name

Is even

Description

Tests if a number is even.

Syntax

ISEVEN(value)

Remarks

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

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

See also ISODD.

Data Type

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

Example

ISEVEN(R1C2)
ISEVEN(B3)
ISEVEN(9) = 0 (False)
ISEVEN(2.4) = 1 (True)
ISEVEN(3.4) = 0 (False)

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