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

Question

我的原始公式是这样：
残疾类别 =IF(坐标="","",CHOOSE(--MID(坐标,19,1),"视力","听力","言语","肢体","智力","精神","多重"))

残疾等级 =IF(坐标="","",CHOOSE(--MID(坐标,20,1),"一级","二级","三级","四级"))
如果证件号只有18位，不是20位，则显示【#VALUE!】

请问如何修改公式，使得它不显示【#VALUE!】，改作显示空白，或【非残疾人】？

Answer 1

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

=IF(ISERR(IF(坐标="","",CHOOSE(--MID(坐标,20,1),"一级","二级","三级","四级"))),"非残疾人",IF(坐标="","",CHOOSE(--MID(坐标,20,1),"一级","二级","三级","四级")))追问

我把你2段代码中第一个【非残疾人】后面的代码全部删除，也能实现，是你打多了么？

原来删除你后面那段话之后，再把位数补成20位，非残疾人就变成FALSE了。

Answer 2

在公式外面加=iferror(你原来的公式,"")

Answer 3

最前面加个IFERROR

即： iferror(原公式,""）追问

iferror=IF(原公式)

iferror(原公式)
iferror=(原公式)
上面3个没反应；

=iferror(原公式)
这个公式错误；

我给你原公式吧，麻烦你直接告诉我成品：

=IF(F16="","",CHOOSE(--MID(F16,19,1),"视力","听力","言语","肢体","智力","精神","多重"))