1. Home
  2. MS Office

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;

=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.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.