原公式:
=IF(C2="","",IF(OR(D2="015",D2="019",D2="630",D2="029",D2="035",D2="039",D2="047"),"A","B"))
可简化为:
=IF(C2="","",IF(OR(D2=TEXT({15,19,630,29,35,39,47},"000")),"A","B"))
如果要比较的数字太多,可以将所有数字预先输入到某列(假定为W列),然后将公式简化为:
=IF(C2="","",IF(COUNTIF(W:W,--D2),"A","B") |