Author: Oscar Cronquist Article last 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:


Excel Function Syntax



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


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