How to generate formula using gender in excel?

How to use the gender generation formula in excel: 1. Enter the formula [IF(MOD(MID(C3,17,1),2)=1,"male","female") in the new table 】; 2. If you are using the if function formula to insert, you can manually fill in the logical value and return value when inserting.

How to use the gender generation formula in excel:

1. First, we need to create a new workbook to proceed demonstration.

2. After creating the new creation, we first determine the row in which we enter the ID card. For example, the ID card is in the C3 row, then the function we need to enter should be IF(MOD(MID (C3,17,1),2)=1,"Male","Female")

3. C3 represents the judgment in the third row of column C Gender input.

4. What needs to be noted here is that C3 is a variable variable and needs to be entered according to your actual situation. For example, if your ID card in the creation form is elsewhere, enter other place.

#5. Also, because of different versions, if you are using a formula to insert the if function.

#6. When inserting, you fill in the logical value and return value yourself. There is no direct formula here.

Recommended tutorial: "excel basic tutorial"

The above is the detailed content of How to generate formula using gender in excel?. For more information, please follow other related articles on the PHP Chinese website!