假设数据在A1，最轮握简公式，不解皮罩释：
=SUMPRODUCT(TEXT(A1-{0,4000,5000,7000},"0;\0"腊握庆)*{1,-0.3,-0.1,-0.1})
=IF(A1<=4000，A1，IF(A1<=5000，4000+(A1-4000)*70%,IF(A1<粗铅困拦=7000，岩尺好4000+(5000-4000)*70%+(A1-5000)*60%,4000+(5000-4000)*70%+(7000-5000)*60%+(A1-7000)*50%)))
=IF(A1<=4000,A1,IF(A1<=5000,(4000+(A1-4000)*0.7),IF(A1<=7000,(A1-5000)*0.6+4000+700,(A1-7000)*0.5+4000+700+1200)))
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024