UC知道关于EXCLE的问题请教.非常着急.谢谢
来源：百度知道 编辑：UC知道 时间：2024/06/27 09:15:23
A B C
21.23% 6,623.93
14.71% 2,905.98
33.33% 961.54
4.95% 18,128.21
当A<3%时,B*0;当3%<=A<5%时,B*0.13%;当5%<=A<10时,B*0.25%;当10%<=A<15时,B*0.5%;当15%<=A<20时,B*0.75%;当20%<=A时,B*1%.
我是这样算的.
=IF(20%<=A4,(B4*1%),IF(15%<=A4<20%,(B4*0.75%),IF(10%<=A4<15%,(B4*0.5%),IF(5%<=A4<10%,(B4*0.25%),IF(3%<=A4<5%,(B4*0.13),0)))))
只能算出大于20%的值呀.是不是太多嵌套了.怎么也算不到.各位拜托了!
21.23% 6,623.93
14.71% 2,905.98
33.33% 961.54
4.95% 18,128.21
当A<3%时,B*0;当3%<=A<5%时,B*0.13%;当5%<=A<10时,B*0.25%;当10%<=A<15时,B*0.5%;当15%<=A<20时,B*0.75%;当20%<=A时,B*1%.
我是这样算的.
=IF(20%<=A4,(B4*1%),IF(15%<=A4<20%,(B4*0.75%),IF(10%<=A4<15%,(B4*0.5%),IF(5%<=A4<10%,(B4*0.25%),IF(3%<=A4<5%,(B4*0.13),0)))))
只能算出大于20%的值呀.是不是太多嵌套了.怎么也算不到.各位拜托了!
先问下楼主，你给的数据是只有A、B两列的值，根据你给的条件
当A<3%时,B*0;当3%<=A<5%时,B*0.13%;当5%<=A<10时,B*0.25%;当10%<=A<15时,B*0.5%;当15%<=A<20时,B*0.75%;当20%<=A时,B*1%.
来计算C列的值吗？
如果是的话，将你的公式更改为以下，应该就对了：
C1==IF(20%<=A1,B1*1%,IF(15%<=A1,B1*0.75%,IF(10%<=A1,B1*0.5%,IF(5%<=A1,B1*0.25%,IF(3%<=A1,B1*0.13%,0)))))
然后将C1的公式向下复制。