Excel执行宏的时候出错，说我语法错误，请问是哪错了。

答案:2 悬赏:50

解决时间 2021-03-15 12:06

提问者网友：活着好累
2021-03-14 12:03

最佳答案

二级知识专家网友：鱼忧
2021-03-14 13:38

正确的语句：
ActiveCell.FormulaR1C1 = "=IF(RC[-1]=""不锈钢"",""不锈钢"",IF(RC[-42]=""定襄"",""寄售"",IF(AND(RC[-42]=""太原"",RC[-29]=""X80M""),""前移"",IF(AND(RC[-42]=""济南"",LEN(RC[-18])>LEN(SUBSTITUTE(RC[-18],""前移"",""""))),""前移"",IF(AND(RC[-42]=""济南"",LEN(RC[-18])>LEN(SUBSTITUTE(RC[-18],""撮合"",""""))),""前移"",IF(AND(RC[-42]=""天津"",RC[-32]=""F""),""前移"",IF(RC[-30]=""硅钢"",""前移"",IF(RC[-39]=""6340"",""寄售"",IF(RC[-39]=""寄售"",IF(RC[-39]=""6360"",""寄售"",""前移""))))))))))"我选中CK1，执行后结果为：
=IF(CJ1="不锈钢","不锈钢",IF(AU1="定襄","寄售",IF(AND(AU1="太原",BH1="X80M"),"前移",IF(AND(AU1="济南",LEN(BS1)>LEN(SUBSTITUTE(BS1,"前移",""))),"前移",IF(AND(AU1="济南",LEN(BS1)>LEN(SUBSTITUTE(BS1,"撮合",""))),"前移",IF(AND(AU1="天津",BE1="F"),"前移",IF(BG1="硅钢","前移",IF(AX1="6340","寄售",IF(AX1="寄售",IF(AX1="6360","寄售","前移"))))))))))

追问：请问我的语法是哪错了？

全部回答

1楼网友：長槍戰八方
2021-03-14 14:49

""太原""双引号都多了。。。去掉一个试试。"太原"

我要举报

如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！