Spread Formula Reference
Formula Functions / Functions H to L / ISEVEN
In This Topic
    ISEVEN
    In This Topic

    This function, Is Number Even, tests whether a value, an expression, or contents of a referenced cell is even.

    Syntax

    ISEVEN(cellreference)

    ISEVEN(value)

    ISEVEN(expression)

    Arguments

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

    Remarks

    If the number specified by the argument is even, the function returns TRUE. If the number specified by the argument is odd, the function returns FALSE. If the number specified by the argument is zero, the function returns TRUE. If the number specified by the argument refers to an empty cell or to no data, the function returns TRUE.

    Use this function to test the contents of a cell, a numeric or text value directly, or a function or expression.

    Data Types

    Accepts numeric data. Returns Boolean (TRUE or FALSE) data.

    Examples

    ISEVEN(B3)

    ISEVEN(R1C2)

    ISEVEN(574) gives the result TRUE

    ISEVEN(9) gives the result FALSE

    ISEVEN(2.4) gives the result TRUE

    ISEVEN(3.6) gives the result FALSE

    ISEVEN(ROUND(3.6)) gives the result TRUE

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    ISODD | EVEN | Information Functions