Exceljet

Quick, clean, and to the point

Excel ISODD Function

Excel ISODD function
Summary 

The Excel ISODD function returns TRUE when a value is an odd number, and FALSE when a value is an even number. ISODD will return the #VALUE error if a value is not numeric.

Purpose 
Test if a value is odd
Return value 
A logical value (TRUE or FALSE)
Syntax 
=ISODD (value)
Arguments 
  • value - The numeric value to check.
Version 
Usage notes 

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.

Examples

The ISODD function returns TRUE or FALSE:

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

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

=ISODD(A1) //returns TRUE

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

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

Notes

  • If value is not numeric, ISODD will return the #VALUE error.
  • Only the integer portion of value is tested; decimal values are truncated.
  • Use the ISEVEN function to test for even numbers.

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.