How to judge whether to combine calculations according to men and women?

1. First, double-click the Excel icon on the desktop-open the Excel form-and enter some ID numbers in the form.

2. Then-enter the formula in cell B2: =IF(MOD(MID(A2,LEN(A2)-1,1),2), "female" and "male").

3. After entering the formula-enter-then put the mouse in the lower right corner of B2 cell-drop down and drag the copy function.

4, just-see all the results.

5. finally-just save the file.