How to extract odd and even numbers in Excel?

#How to extract odd and even numbers in Excel?

How to extract odd and even numbers in Excel:

1. First, open the Excel form on the computer, and then enter the data to be filtered, as follows As shown in the figure.

2. Secondly, after completing the above steps, enter the formula "=IF(MOD(RIGHT(A1,1),2)=0," in cell B1 Double","single")", as shown in the figure below.

#3. Then, after completing the above steps, press the Enter key to obtain the odd and even numbers of the data, as shown in the figure below.

4. Finally, place the left mouse button on the lower right corner of cell B1, and use the mouse to pull down to copy the formula, as shown in the figure below. In this way, all the data is processed and the problem is solved.

Recommended tutorial: "excel basic tutorial"

The above is the detailed content of How to extract odd and even numbers in Excel?. For more information, please follow other related articles on the PHP Chinese website!