excel显示您以为此函数输入太多个参数怎么办，求帮助

2025-05-09 04:05:51

推荐回答（2个）

回答1：

这里少一个括号，最后多一个括号。

=IF(C13="","",IF(OR(B13="PE弯头",B13="铸铁弯头"),IF(RIGHT(C13,4)="22.5","DN"&LEFT(C13,LEN(C13)-4)&"×"&"22.5"&"°","DN"&LEFT(C13,LEN(C13)-2)&"×"&RIGHT(C13,2)&"°"),IF(AND(LEFT(C13,4)="1000",C13>3000),"DN"&"1000"&"×"&RIGHT(C13,LEN(C13)-4),IF(LEFT(C13,4)="1000","DN"&C13,IF(C13="","",IF(C13>99999,"DN"&LEFT(C13,3)&"×"&RIGHT(C13,3),IF(AND(C13<99999,C13>3000),"DN"&LEFT(C13,LEN(C13)-2)&"×"&RIGHT(C13,2),"DN"&C13)))))))

回答2：

=ROUND(IF(MID(Sheet1!A1,1,FIND("（",Sheet1!A1))="好（",(RAND()*(200-198)+198),IF(MID(Sheet1!A1,1,FIND("（",Sheet1!A1))="较好(",(RAND()*(100-90)+90),IF(MID(Sheet1!A1,1,FIND("（",Sheet1!A1))="一般(",(RAND()*(10-1)+1),100))),0),你少了两个右括号
IF(MID(Sheet1!A1,1,FIND("（",Sheet1!A1)="较好(",(RAND()*(100-90)+90)，应为IF(MID(Sheet1!A1,1,FIND("（",Sheet1!A1))="较好(",(RAND()*(100-90)+90)
IF(MID(Sheet1!A1,1,FIND("（",Sheet1!A1)="一般(",(RAND()*(10-1)+1)，应为IF(MID(Sheet1!A1,1,FIND("（",Sheet1!A1))="一般(",(RAND()*(10-1)+1)