UC知道EXCEL 这样的。
来源：百度知道 编辑：UC知道 时间：2024/06/20 08:33:20
D8=0
B12=940
D8=1
B12=940*1%
D8=2
B12=940*1.5%
D8=3
B12=940*2.1%
D8=4
B12=940*3.0%
D8=5
B12=940*8.0%
D8=6
B12=940*11%
D8=7
B12=940*14.5%
D8=8
B12=940*23.5%
D8=9
B12=940*30%
D8=10
B12=940*39.3
B12等于需要为后面的和值就可以了。谢谢
B12=940
D8=1
B12=940*1%
D8=2
B12=940*1.5%
D8=3
B12=940*2.1%
D8=4
B12=940*3.0%
D8=5
B12=940*8.0%
D8=6
B12=940*11%
D8=7
B12=940*14.5%
D8=8
B12=940*23.5%
D8=9
B12=940*30%
D8=10
B12=940*39.3
B12等于需要为后面的和值就可以了。谢谢
用 choose函数或者hlookup,LOOKUP可以解决的！
B12=940*(LOOKUP(D8,{0,1;1,0.01;2,0.015;3,0.021;4,0.03;5,0.08;6,0.11;7,0.145;8,0.235;9,0.3;10,0.393}))
在B12中输入：
=AND(D8=0)*940+AND(D8=1)*940*1%+AND(D8=2)*940*1.5%+AND(D8=3)*940*2.1%+AND(D8=4)*940*3%+AND(D8=5)*940*8%+AND(D8=6)*940*11%+AND(D8=7)*940*14.5%+AND(D8=8)*940*23.5%+AND(D8=9)*940*30%+AND(D8=10)*940*39.3%
B12=940*(LOOKUP(B8,{0,1;1,0.01;2,0.015;3,0.021;4,0.03;5,0.08;6,0.11;7,0.145;8,0.235;9,0.3;10,0.393}))