Excel中设置以下公式显示：您已输入太多参数。如何解决啊，各位大侠们

发布网友发布时间：2022-06-08 01:13

共4个回答

热心网友时间：2023-11-02 03:09

=IF(AND(H3>=10000,H3<20000),0.035,IF(AND(H3>=20000,H3<=30000),0.03,IF(AND(H3>30000,H3<40000),0.02,IF(AND(H3>40000,H3<50000),0.03,"?"))))

? 是不满足你给出条件的部分所得的结果！
你原来的公式括号的位置不对！要注意嵌套函数的条件位置你的原嵌套逻辑是有几个if 最后就加几个括号！另外最后两个条件是开区间自己检查修改一下否则等于的情况将都被放置在？所在的位置……
具体你要进行的逻辑运算不清楚所以只能给出你原公式括号位置错误的修改……其他需要你自己来做了

热心网友时间：2023-11-02 03:09

多了两个括号，改了一下，试试看。
=IF(AND(H3>=10000,H3<20000),0.035,IF(AND(H3>=20000,H3<=30000),0.03,IF(AND(H3>30000,H3<40000),0.02,IF(AND(H3>40000,H3<50000),0.03))))

热心网友时间：2023-11-02 03:10

修改如下：
=IF(AND(H3>=10000,H3<20000),0.035,IF(AND(H3>=20000,H3<30000),0.03,IF(AND(H3>=30000,H3<40000),0.02,IF(AND(H3>=40000,H3<50000),0.03,""))))
或简化为
=IF(OR(H3="",H3<10000,H3>=50000),"",LOOKUP(H3,{10000,20000,30000,40000},{0.035,0.03,0.02,0.03}))

热心网友时间：2023-11-02 03:10

=LOOKUP(A1,{10000,20000,30000,40000,50000},{0.035,0.03,0.02,0.03,0})