230问答网 > 关于EXCEL函数应用问题，可能涉及ceiling的带入，求解答

关于EXCEL函数应用问题，可能涉及ceiling的带入，求解答

2024-12-26 05:20:51

推荐回答（2个）

回答1：

取整：
=INT((IF(B3<=1000000,B3*0.005,IF(B3<=5000000,5000+(B3-1000000)*0.003,IF(B3<=10000000,5000+4000000*0.003+(B3-5000000)*0.002,IF(B3>10000000,5000+(5000000-1000000)*0.003+(10000000-5000000)*0.002+(B3-10000000)*0.001,0))))))*D5

向上取整：
=ROUNDUP((IF(B3<=1000000,B3*0.005,IF(B3<=5000000,5000+(B3-1000000)*0.003,IF(B3<=10000000,5000+4000000*0.003+(B3-5000000)*0.002,IF(B3>10000000,5000+(5000000-1000000)*0.003+(10000000-5000000)*0.002+(B3-10000000)*0.001,0))))),0)* D5

四舍五入取整：
=ROUND((IF(B3<=1000000,B3*0.005,IF(B3<=5000000,5000+(B3-1000000)*0.003,IF(B3<=10000000,5000+4000000*0.003+(B3-5000000)*0.002,IF(B3>10000000,5000+(5000000-1000000)*0.003+(10000000-5000000)*0.002+(B3-10000000)*0.001,0))))),0)* D5

回答2：

=ceiling((IF(B3<=1000000,B3*0.005,IF(B3<=5000000,5000+(B3-1000000)*0.003,IF(B3<=10000000,5000+4000000*0.003+(B3-5000000)*0.002,IF(B3>10000000,5000+(5000000-1000000)*0.003+(10000000-5000000)*0.002+(B3-10000000)*0.001,0))))),1)*D5