...个残疾证号(20位数)想通过excel函数提取残疾类别和残疾等级,怎么弄...答:残疾等级:\x0d\x0a=TEXT(--RIGHT(A1,1),"[dbnum1]")&"级"\x0d\x0a\x0d\x0a残疾类别:\x0d\x0a=LOOKUP(--MID(A1,19,1),{1,2,3,4,5,6,7},{"听力","视力","言语","肢体","智力","精神","多重"})\x0d\x0a\x0d\x0a合并:\x0d\x0a=LOOKUP(--MID(A1...
...例如:110221195806010233,想通过excel函数提取残疾类别和残疾...答:残疾类别:=LOOKUP(--MID(A1,19,1),{1,2,3,4,5,6,7},{"听力","视力","言语","肢体","智力","精神","多重"})合并:=LOOKUP(--MID(A1,19,1),{1,2,3,4,5,6,7},{"听力","视力","言语","肢体","智力","精神","多重"})&TEXT(--RIGHT(A1,1),"[dbnum1]")&"级...
【Excel公式】在根据残疾证号判断残疾类别和等级的基础上,如何让公式...答:=IF(ISERR(IF(坐标="","",CHOOSE(--MID(坐标,19,1),"视力","听力","言语","肢体","智力","精神","多重"))),"非残疾人",IF(坐标="","",CHOOSE(--MID(坐标,19,1),"视力","听力","言语","肢体","智力","精神","多重")))=IF(ISERR(IF(坐标="","",CHOOSE(--MID(坐...
excel中,输入残疾证号,如何根据倒数第二位数值 自动输出 残疾类别答:在B1输入公式下拉,如下图 =IF(A1="","",CHOOSE(--MID(A1,19,1),"视力","听力","言语","肢体","智力","精神","多重"))
求EXCEL大神给弄个公式 要求如下 根据残疾证号来判断残疾类别和残疾等级...答:可以用if()套用,或用lookup(),你公式放在哪个单元格?如果证号放在C9,公式:=LOOKUP(MID(C9,19,1)*1,{1,2,3,4,5,6},{"视力","听力","言语","肢体","智力","精神"})&MID(C9,20,1)&"级"
请教如何能通过excel函数公式自动计算残疾证号证号年龄、残疾类别、残...答:是这样的结果吗:肢体等级的判断您没有说清楚望说明43是三级52是什么呢?其它数又是什么意思 B2=DATEDIF(TEXT(TEXT(--MID(A2,6,8),"0000-00-00"),"yyyy-mm-dd"),TODAY(),"y")C2=IF(--RIGHT(A2,2)=43,"三级","")D2=RIGHT(A2,1)&"级"...