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;



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.