人人做人人澡人人爽欧美,国产主播一区二区,久久久精品五月天,羞羞视频在线观看免费

當(dāng)前位置:蘿卜系統(tǒng) > 硬件軟件教程 > 詳細(xì)頁面

用于檢查輸入ID號碼正確性的Excel函數(shù)公式

用于檢查輸入ID號碼正確性的Excel函數(shù)公式

更新時(shí)間:2023-06-20 文章作者:未知 信息來源:網(wǎng)絡(luò) 閱讀次數(shù):

根據(jù)運(yùn)行的環(huán)境,操作系統(tǒng)可以分為桌面操作系統(tǒng),手機(jī)操作系統(tǒng),服務(wù)器操作系統(tǒng),嵌入式操作系統(tǒng)等。

號碼檢測_身份號碼抽取年份_用號和姓名查詢社保號碼

= IF(LEN($ G2)= 18,IF(RIGHT($ G2,1)=“ X”,IF(CHOOSE(MOD(SUM(LEFT(RIGHT($ G2,18))** 7 + LEFT (RIGHT($ G2,17))* 9 + LEFT(RIGHT($ G2,16))* 10 + LEFT(RIGHT($ G2,15))* 5 + LEFT(RIGHT($ G2,14))* 8 + LEFT(RIGHT($ G2,13))* 4 + LEFT(RIGHT($ G2,11))* 2 + LEFT(RIGHT($ G2,11))* 1 + LEFT(RIGHT($ G2,10)) * 6 + LEFT(RIGHT($ G2,9))* 3 + LEFT(RIGHT($ G2,8))* 7 + LEFT(RIGHT($ G2,7))* 9 + LEFT(RIGHT($ G2,6) ))* 10 + LEFT(RIGHT($ G2,5))* 5 + LEFT(RIGHT($ G2,4))* 8 + LEFT(RIGHT($ G2,3))* 4 + LEFT(RIGHT($ G2) ,2))* 2),11)+1,1,0,“ X”,9,8,7,6,5,4,3,2)= LEFT(RIGHT($ G2,1)),“正確!“,”出問題了!“),IF(選擇(MOD(SUM(LEFT(RIGHT($ G2,18))** 7 + LEFT(RIGHT($ G2,17))* 9 + LEFT(RIGHT( $ G2,16))* 10 + LEFT(RIGHT($ G2,15))* 5 + LEFT(RIGHT($ G2,14))* 8 + LEFT(RIGHT($ G2,13))* 4 + LEFT( RIGHT($ G2,12))* 2 + LEFT(RIGHT($ G2,11))* 1 + LEFT(RIGHT($ G2,10))* 6 + LEFT(RIGHT($ G2,9))* 3+ LEFT(RIGHT($ G2,8))* 7 + LEFT(RIGHT($ G2,7))* 9 + LEFT(RIGHT($ G2,6))* 10 + LEFT(RIGHT($ G2,5))* 5 + LEFT(RIGHT($ G2,4))* 8 + LEFT(RIGHT($ G2,3))* 4 + LEFT(RIGHT($ G2,2))* 2),11)+1,1,0號碼檢測,“ X”,9,8,7,6,5,4,3,2)= LEFT(RIGHT($ G2,1))* 1,“ Correct!”號碼檢測,“ Error!”)),IF(LEN ($ G2)= 15, “舊數(shù)字,請注意!”,IF(LEN($ G2)= 0,“缺少數(shù)字”,“數(shù)字錯(cuò)誤!”))))


本文來自本站,轉(zhuǎn)載請注明本文網(wǎng)址:
http://www.pc-fly.com/a/jisuanjixue/article-287321-1.html



溫馨提示:喜歡本站的話,請收藏一下本站!

本類教程下載

系統(tǒng)下載排行

網(wǎng)站地圖xml | 網(wǎng)站地圖html
主站蜘蛛池模板: 揭西县| 大新县| 安龙县| 乌兰浩特市| 嵊泗县| 禹城市| 灵山县| 东乌| 西畴县| 延庆县| 容城县| 靖西县| 焦作市| 麻栗坡县| 额敏县| 铜陵市| 马龙县| 清河县| 苍南县| 元氏县| 鄂托克前旗| 云龙县| 太白县| 资溪县| 樟树市| 兴和县| 定西市| 深泽县| 恩平市| 江口县| 安义县| 广东省| 长海县| 湾仔区| 舟山市| 奈曼旗| 嘉黎县| 东港市| 丽江市| 河津市| 莲花县|