您的位置首页百科知识

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

Simone 发布于 2023-10-26 15:49:17 550 阅读

【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

相关文章

1 表白公式520.1314 帮忙写一下全部的过程谢谢

573 阅读

2 excel如何筛选后去重计数

613 阅读

3 怎么从手机上把金山文档的文件转成excel

574 阅读

4 怎么在手机上把照的图转成Excel

603 阅读

5 wps和excel有区别吗？区别在哪里？

669 阅读