在excel中“您已为此函数输入太多个参数”是什么意思，有什么解决办法

这个公式哪里错了？显示“您已为此函数输入太多个参数”IF(LEN(E4)=19,IF(LEFT(G4,10)="PrimaSleep","GIAMZ-MC",IF(LEF... 这个公式哪里错了？显示“您已为此函数输入太多个参数”
IF(LEN(E4)=19,IF(LEFT(G4,10)="PrimaSleep","GIAMZ-MC",IF(LEFT(G4,4)="Olee","GLAMZ-MC",IF(LEFT(G4,9)="SLEEPLACE","SKAMZ-MC", IF(LEFT(G4,4)="Ecos", "ECAMZ-MC","Warning"))),IF(AND(LEN(E4)<=5,LEN(E4)>0),"GLEBY-MC",IF(LEN(E4)=9,IF(LEFT(G4,11)="Sleeplanner","GLOSK-MC","GLNEG-MC"),"Warning"))) 展开

 我来答

2个回答

#热议# 生活中有哪些实用的心理学知识？

laorenjia1987
2018-10-22 · TA获得超过2765个赞

知道大有可为答主

回答量：1734

采纳率：73%

帮助的人：431万

我也去答题访问个人页

关注

展开全部

最外面的if 的 第二个参数漏了个右括号：
=IF(LEN(E4)=19,IF(LEFT(G4,10)="PrimaSleep","GIAMZ-MC",IF(LEFT(G4,4)="Olee","GLAMZ-MC",IF(LEFT(G4,9)="SLEEPLACE","SKAMZ-MC",IF(LEFT(G4,4)="Ecos","ECAMZ-MC","Warning")))),IF(AND(LEN(E4)<=5,LEN(E4)>0),"GLEBY-MC",IF(LEN(E4)=9,IF(LEFT(G4,11)="Sleeplanner","GLOSK-MC","GLNEG-MC"),"Warning")))

本回答被提问者采纳

已赞过已踩过<

你对这个回答的评价是？
评论收起