EXCEL中残疾证不符合校验规则怎么运用函数计算？

更新时间2018-07-05 13:19:42

excel中 残疾证不符合校验规则 怎么运用函数计算？

没有规则就无法校核。

请将校验规则说出来

这个要看具体内容才知道如何修改。

把你的表格贴出来看看？

=IF(ISERR(IF(坐标="","",CHOOSE(--MID(坐标,19,1),"视力","听力","言语","肢体","智力","精神","多重"))),"非残疾人",IF(坐标="","",CHOOSE(--MID(坐标,19,1),"视力","听力","言语","肢体","智力","精神","多重")))=IF(ISERR(IF(坐标="","",CHOOSE(--MID(坐标,20,1),"一级","二级","三级","四级"))),"非残疾人",IF(坐标="","",CHOOSE(--MID(坐标,20,1),"一级","二级","三级","四级")))

【excel公式】在根据残疾证号判断残疾类别和等级的基础上，如何让公式智能识别非残疾人？_百度知道

https://zhidao.baidu.com/question/304006268724250284.html