excel中公式错误，说让在第一个字符前输入“

更新时间2019-01-14 04:49:39

=IF(COUNTIF(C3,"*JJ*"),"CJZX",IF(COUNTIF(C3,"*P*"),"PFTZ",IF(COUNTIF(C3,"*2018004*"),"PFTY",IF(COUNTIF(C3,"*J2019013*"),"HJZY",IF(COUNTIF(C3，"*2019013*"),"HJYX"，IF(COUNTIF(C3,"*H*"),"HPWT",IF(COUNTIF(C3,"*2019012*"),"HPHH",IF(COUNTIF(C3,"*20180100*"),"HYSM","")))))))

选择是后为：

excel中公式错误，说让在第一个字符前输入“

=IF(COUNTIF(C3,"*JJ*"),"CJZX",IF(COUNTIF(C3,"*P*"),"PFTZ",IF(COUNTIF(C3,"*2018004*"),"PFTY",IF(COUNTIF(C3,"*J2019013*"),"HJZY",IF(COUNTIF(C3,"*2019013*"),"HJYX",IF(COUNTIF(C3,"*H*"),"HPWT",IF(COUNTIF(C3,"*2019012*"),"HPHH",IF(COUNTIF(C3,"*20180100*"),"HYSM",""))))))))

如果公式的计算结果不是你想要的，那么再继续修改吧。

你没有说明你的计算规则，所以就不好修改你的公式了。

你的公式复制黏贴到单元格后，按确定，就能自动修改错误的，得到正确的结果如下：

好像公式没有什么错误，除了少了一个括号和不知道为什么要在条件加*号以外