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:


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


Example of ISODD Function in Excel:


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.


ISODD Function in Excel 2

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

DataScience Made Simple