在excel中“您已为此函数输入太多个参数”是什么意思，有什么解决办法
答案:2 悬赏:10 手机版
解决时间 2021-01-11 15:53
- 提问者网友：兔牙战士
- 2021-01-10 23:18
在excel中“您已为此函数输入太多个参数”是什么意思，有什么解决办法
最佳答案
- 五星知识达人网友：未来江山和你
- 2021-01-10 23:36
最外面的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")))
=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")))
全部回答
- 1楼网友：我住北渡口
- 2021-01-11 00:57
前面应该是ifs。望采纳
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯