How to determine gender using mod function

How to determine gender by mod function

The first step, everyone knows that the second to last digit on the ID card Parity determines people's gender, so. Before we use the excel function, we need to analyze its principle. Since we judge based on the penultimate digit, right, our first step is to take out the number, then judge the parity of the number, and finally use the if function To make logical judgments, let’s do it step by step.

Recommendation: "Excel Tutorial"

Enter the certificate number first. Before entering, please note that Change the cell format to text format,

Use the interception string functions left(), right(), mid(), of course, the penultimate digit of the ID card is located In the middle of the string, so here we use the mid() function to extract characters.

Use the mod() remainder function to determine parity. The divisor is 2. If the remainder If it is 0, it is an even number, and vice versa. Everyone knows this.

Finally, use the if() function for logical judgment. Everyone knows how to use this. You can find out as shown below.

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