ISODD

Excel Functions

Test if a value is odd

Syntax

EXCEL

=ISODD(value)

Arguments

Parameter	Description
`value`	The numeric value to check.

Return Value

A logical value (TRUE or FALSE)

Details

The ISODD function tests for odd numbers. ISODD takes one argument, value, which should be a numeric value or a cell reference. When value is an odd number, ISODD returns TRUE. When value is an even number, ISODD returns FALSE. If value is not numeric, ISODD will return the #VALUE error. Only the integer portion of value is evaluated, decimal values are truncated. The ISODD function returns TRUE or FALSE: If cell A1 contains 11, the formula below returns TRUE: Only the integer portion of value is tested. If value is a decimal number, the decimal portion is truncated:

Examples

The ISODD function returns TRUE or FALSE:

EXCEL

=ISODD(4) // returns FALSE
=ISODD(3) // returns TRUE
=ISODD(0) // returns FALSE

Examples

If cell A1 contains 11, the formula below returns TRUE:

EXCEL

=ISODD(A1) //returns TRUE

Examples

Only the integer portion of value is tested. If value is a decimal number, the decimal portion is truncated:

EXCEL

=ISODD(4.1) // returns FALSE
=ISODD(0.33) // returns FALSE
=ISODD(7.4) // returns TRUE

ISODD

Syntax

Arguments

Return Value

Details

Examples

See Also