引用 Excel常用电子表格公式大全（Reference Excel commonly used spreadsheet formula Daquan）.docVIP

引用 Excel常用电子表格公式大全（Reference Excel commonly used spreadsheet formula Daquan） 1, find duplicate content formula: =IF (COUNTIF (A:A, A2) 1, repeat, ). 2, use birth date to calculate age formula: =TRUNC ((DAYS360 (H6, 2009/8/30, FALSE)) /360,0). 3, from the input of the 18 ID card number of birth months to calculate formula: =CONCATENATE (MID (E2,7,4), / /, MID (E2,11,2), / /, MID (E2,13,2)). 4, from the input ID number, so that the system automatically extract gender, you can enter the following formula: =IF (LEN (C2) =15, IF (MOD (MID (C2,15,1), 2), =1, male, female), IF (MOD (MID (C2,17,1), 2)