在I3中输入或复制粘贴下列公式
=IF(H3="","",LOOKUP(H3,{0,1,1.5,2,2.5,3}*10000,{5,6,7,8,9,10}%))
下拉填充
I3:
=lookup(H3,{0,10000,15000,20000,25000,30000},{0.05,0.06,0.07,0.08,0.09,0.1})
===============
I3:
=H3*lookup(H3,{0,10000,15000,20000,25000,30000},{0.05,0.06,0.07,0.08,0.09,0.1})
=FLOOR(MIN(30000,MAX(9999.99,H3))/5000,1)%+4%
LOOKUP(H3,{0;10000;14999;24999;29999;30000},{0.05;0.06;0.07;0.08;0.09;0.1})
使用IF函数
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024