Excel 2010: Categorize Numeric Values Into Even & Odd Groups

Using ISODD function in Excel 2010, you can categorize numeric values into Even & Odd groups. It returns True in an event of finding Odd number and conversely is the case with finding a even number.

You can also enter direct values in argument but we will be specifying location of the cells. The syntax goes like this;



Drag the plus sign at the end of the cell to the bottom for applying the formula over the column.