The ISODD Excel function is an Information formula that returns TRUE if the number argument is an odd number, or FALSE if it’s even. You can test the result of a formula or value of a cell using this function. In this guide, we’re going to show you how to use the ISODD function and also go over some tips and error handling methods.


Supported versions

  • All Excel versions

ISODD Excel Function Syntax

ISODD(number)


Arguments

number The number you want to test.

Example

The ISODD function, just like the other IS… functions, only requires a single argument as an input. The function returns a TRUE logical value if the number argument is an odd number. If the number has decimals, the ISODD function truncates the number argument. A common use case of this function is testing the value of cell or value that is returned by a formula.

=ISODD(1) returns TRUE

=ISODD(2) returns FALSE

Download Workbook


Tips

  • You can use the ISODD function for the logical test component of an IF function.
    =IF(ISODD(A1),”Odd number”,”Even number”)
  • If the number is not a whole number, the ISODD function truncates the numeric value.
  • Excel keeps date and time values as numbers. Excel assumes that Jan 1st, 1900 is 1, and every subsequent date value is based on this. While whole numbers represent days, decimals represent time values. For example; 1/1/2018 is equal to 43101, and 12:00 is equal to 5. Because of this, the ISODD function counts date time values as numbers.
  • Below is a list of other IS… functions:
    • ISBLANK to test blank cells
    • ISERR to test error values except #N/A
    • ISERROR to test all error values
    • ISNA to test #N/A error value specifically
    • ISNUMBER to test numbers
    • ISTEXT to test any item that is a text
    • ISNONTEXT to test any item that is not a text
    • ISEVEN to test even numbers
    • ISREF to test if a formula returns a reference

Issues

  • If the number argument is not a valid numeric value, the ISODD function returns a #VALUE! error.