search

Home >Topics >excel >Excel extracts gender based on ID number

Excel extracts gender based on ID number

王林
王林Original
2019-12-24 13:14:4021193browse

Excel extracts gender based on ID number

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

Excel extracts gender based on ID number

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

Excel extracts gender based on ID number

3. After entering the formula, press Enter, then place the mouse on the lower right corner of cell B2, drag down to copy the function

Excel extracts gender based on ID number

4, that is You can see all the results

Excel extracts gender based on ID number

#5. Finally, save the file.

Excel extracts gender based on ID number

Recommended related articles and tutorials: excel tutorial

The above is the detailed content of Excel extracts gender based on ID number. For more information, please follow other related articles on the PHP Chinese website!

if len excel
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Cross-table use of vlookup function in excelNext article：Cross-table use of vlookup function in excel

Related articles

See more