How to use excel gender function

How to use excel gender function?

How to use excel gender function

First we need to create a new workbook for demonstration.

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")

where C3 represents the gender input in the third row of column C.

It should be noted here that C3 is a variable variable and needs to be entered according to your actual situation. For example, if your creation form ID card is elsewhere, enter it elsewhere.

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

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

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

The above is the detailed content of How to use excel gender function. For more information, please follow other related articles on the PHP Chinese website!