能帮我把所有红色标记的单元格公式改进一下,让数据没有数据时显示0,而不显示错误信息E7=IF(MOD(IF(LEN(D7)=18,MID(D7,17,1),MID(D7,17,1)),2)=1,"男","女")G7=DATE(YEAR(E7)+(D7="男")*5+55,MONTH(E7),DAY(E7)+1)H7=IF(ISERROR(LOOKUP(--MID(C7,19,1),{1,2,3,4,5,6,7},{"视力残疾","听力残疾","言语残疾","肢体残疾","智力残疾","精神残疾","多重残疾"})),0,LOOKUP(--MID(C7,19,1),{1,2,3,4,5,6,7},{"视力残疾","听力残疾","言语残疾","肢体残疾","智力残疾","精神残疾","多重残疾"}))I7=IF(C7=0,0,IF(ISERROR(TEXT(--RIGHT(C7,1),"[dbnum1]")&"级"),0,TEXT(--RIGHT(C7,1),"[dbnum1]")&"级"))