EXCEL中残疾证不符合校验规则怎么运用函数计算?
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
上一篇:函数的一个x可以对应两个y吗
热门标签: