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:


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.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.