Question

显示我输入的函数参数过多，请指教

=IF(E4>0.6,2%*D4,IF(E4>=0.8,2.5%*D4,IF(E4>=99%,2.5%*D4,IF(E4=100%,3.5%*D4,IF(,E4>100%,((D4-C4)*4%+C4*3.5%)),IF(E4=120%,((D4-C4)*4%+C4*3.5%)),IF(E4>120%,D4*4%,0) 显示我输入的函数参数过多，请指教

Answer 1

依你的公式修正：
=IF(E4>120%,D4*4%,IF(E4=120%,(D4-C4)*4%+C4*3.5%,IF(E4>100%,(D4-C4)*4%+C4*3.5%,IF(E4=100%,3.5%*D4,IF(E4>=99%,2.5%*D4,IF(E4>=0.8,2.5%*D4,IF(E4>0.6,2%*D4,0)))))))
但不知你为何要写得这麼罗嗦?如下缩简一下不是更简单明瞭吗?
=IF(E4>1.2,D4*4%,IF(E4>1,(D4-C4)*4%+C4*3.5%,IF(E4=1,3.5%*D4,IF(E4>=0.8,2.5%*D4,IF(E4>0.6,2%*D4,0)))))
=IF(E4>1.2,D4*4,IF(E4>1,(D4-C4)*4+C4*3.5,IF(E4=1,3.5*D4,IF(E4>=0.8,2.5*D4,IF(E4>0.6,2*D4,0)))))%