Excel extracts gender based on ID number
- 王林Original
- 2019-12-24 13:14:4021074browse
1. First, double-click the Excel icon on the desktop, open the Excel table, and enter some ID numbers in the table
2. Then, enter the formula in cell B2: =IF(MOD(MID(A2,LEN(A2)-1,1),2),"Female","Male")
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
4, that is You can see all the results
#5. Finally, save the file.
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!
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