...110221195806010233,想通过excel函数提取残疾类别和残疾等级...答:残疾等级:=TEXT(--RIGHT(A1,1),"[dbnum1]")&"级"残疾类别:=LOOKUP(--MID(A1,19,1),{1,2,3,4,5,6,7},{"听力","视力","言语","肢体","智力","精神","多重"})合并:=LOOKUP(--MID(A1,19,1),{1,2,3,4,5,6,7},{"听力","视力","言语","肢体","智力","精神",...
...要求如下 根据残疾证号来判断残疾类别和残疾等级答:可以用if()套用,或用lookup(),你公式放在哪个单元格?如果证号放在C9,公式:=LOOKUP(MID(C9,19,1)*1,{1,2,3,4,5,6},{"视力","听力","言语","肢体","智力","精神"})&MID(C9,20,1)&"级"