[已解决]提成计算公式（2003或2010版均可）谢谢！

Excel180

提成计算公式（见附件）谢谢！

最佳答案

月排行榜 / 总排行榜

baksy

2014-12-21 10:29

=MIN(IF(B2<={50,90,999},{0,0.06,0.22}))+(B2-MIN(IF(B2<={50,90,999},{0,50,90})))*MIN(IF(B2<={50,90,999},{0.0012,0.004,0.008}))

跳转到最佳答案楼层

xuyouxm

工作簿1.zip (6.64 KB, 下载次数: 13)

2014-12-21 10:06 上传

点击文件名下载附件

是这样吗？


=IF(B2>90,500000*0.0012+400000*0.004+(B2*10000-900000)*0.08,IF(B2>50,500000*0.0012+(B2*10000-500000)*0.004,B2*10000*0.0012))

公式写错了一个。

Excel180

xuyouxm 发表于 2014-12-21 10:06
是这样吗？

baksy

=MIN(IF(B2<={50,90,999},{0,0.06,0.22}))+(B2-MIN(IF(B2<={50,90,999},{0,50,90})))*MIN(IF(B2<={50,90,999},{0.0012,0.004,0.008}))

Excel180

baksy 发表于 2014-12-21 10:29
=MIN(IF(B2

谢谢您的公式，但是不知道0.22是怎么来的
MIN(IF(B2<={50,90,999},{0,0.06,0.22}))+(B2-MIN(IF(B2<={50,90,999},{0,50,90})))*MIN(IF(B2<={50,90,999},{0.0012,0.004,0.008}))

丢丢表格

baksy 发表于 2014-12-21 10:29
=MIN(IF(B2

是典型 的个税计算方式（累进计算法）
可以用 TEXT
=SUM(TEXT(B2-{0,50,90},"[<]!0")*{12,28,40})

xuyouxm

=IF(B2>90,500000*0.0012+400000*0.004+(B2*10000-900000)*0.08,IF(B2>50,500000*0.0012+(B2*10000-500000)*0.004,B2*10000*0.0012))

有一个小地方写错了，修改一下就OK了！