Excel 2010: Categorize Numeric Values Into Even & Odd Groups

Advertisement

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;

=ISODD(number)

998d1277893291-categorize-values-even-odd-values-

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

Advertisement