ISODD

This function, Is Number Odd, tests whether a value, an expression or contents of a referenced cell has numeric data.

Syntax

ISODD(cellreference)

ISODD(value)

ISODD(expression)

Arguments

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

Remarks

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

• If the number specified by the argument is odd, the function returns TRUE.

• If the number specified by the argument is even, the function returns FALSE.

• If the number specified by the argument is zero, the function returns FALSE.

• If the number specified by the argument refers to an empty cell or no data, the function returns TRUE.

Examples

ISODD(B3)

ISODD(R1C2)

ISODD(12) gives the result FALSE

ISODD(2.5) gives the result FALSE

ISODD(3.6) gives the result TRUE

ISODD(ROUND(3.6)) gives the result FALSE