How to calculate the gender of ID card with if function?

1. First of all, in the spreadsheet, ask the second-to-last digit of the ID number to judge the gender, with odd numbers for men and even numbers for women, and use the function to find the gender.

2. Enter "=MID ()" in the cell, as shown.

3. Call up the function formula. Let's look at the first parameter. Let's take the ID number, which is the E2 cell.

4. Because the age is judged by the penultimate digit of the ID number, we take the value of 13, that is, the second parameter is 13, because we take the digit of 1, that is, the third parameter is 1.

5. Insert the separable conditional function MOD, and enter "MOD" before the edit box MID.

6. Enter the second parameter 2 in the function formula.

7. If conditions are used to judge whether odd numbers are male or even numbers are female, that is, 1 is male and 0 is female. Specific parameters are shown in the figure.

8. It can be finished at last.