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","")))))))
选择是后为：
=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",""))))))))
如果公式的计算结果不是你想要的，那么再继续修改吧。
你没有说明你的计算规则，所以就不好修改你的公式了。
你的公式复制黏贴到单元格后，按确定，就能自动修改错误的，得到正确的结果如下：
=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",""))))))))
好像公式没有什么错误，除了少了一个括号和不知道为什么要在条件加*号以外