假如数据在A列， B1格子写入下列公式
=IF(A1>10000,"超过1万",IF(A1>5000,3000*0.005+2000*0.01+(A1-5000)*0.015,IF(A1>3000,3000*0.005+(A1-3000)*0.01,A1*0.005)))
假设输入的数字在A1单元格
=if(A1<=3000,A1*0.005,if(A1<=5000,15+(A1-3000)*0.01,35+(A1-5000)*0.015))
试一下：
=MAX(A1*{0.005,0.01,0.015}-{0,15,40})
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024