ISODD Function in Excel – Test the Odd number in Excel

ISODD Function in Excel tests if a supplied number (or numeric expression) evaluates to an odd number, if so then the Function returns TRUE, if not the function returns FALSE.

Syntax of ISODD Function in Excel:

ISODD(value)

Where value argument is the Expression or value to be tested for odd number.

 

Example of ISODD Function in Excel:

Formula:

ISODD Function in Excel 1

  • The above example takes up simple values and cell reference as input and returns TRUE only if the resultant value is an odd number, otherwise the function returns FALSE
  • Excel ISODD Function, also considers odd Decimals as odd numbers. So 71.34 is considered as odd.

Result:

ISODD Function in Excel 2

previous-small ISODD Function in Excel                                                                                                                next_small ISODD Function in Excel