Article updated on April 17, 2018

The ISODD function returns TRUE if a cell contains an odd number, FALSE if even number.

Formula in cell C6:

=ISODD(B3)

Excel Function Syntax

ISODD(number)

Arguments

number Required. The value you want to check for an odd number.

Comments

The ISODD function is different from the other IS functions, it does not return FALSE for error values like #N/A, #REF, #VALUE etc.