|
本帖最后由 wljsxz 于 2014-5-4 16:50 编辑
销售收款日报表 | | 制单日期 | | | | | | | | | | | | | 收款日期 | 客户编码 | 客户名称 | 货款所属月份 | 收款金额 | 收款期限 | 到期日期 | 逾期日子 | 业务费系数 | 奖罚系数 | 业务费 | 业务员 | 备注 | | 4-25 | | | 2-25 | 50000 | 60 | 2014-4-26 | -1 | 0.50% | 0.10% | 300 | | | | 3-25 | | | 12-5 | 50000 | 60 | 2014-2-3 | 50 | 0.50% | -0.13% | 185 | | | | | | | | | | 1900-1-0 | 0 | 0.50% | | 0 | | | | | | | | | | | | | | | | | | 奖罚系数表 | | | | | | | | | | | | | 系数范围 | 系数 | | | | | | | | | | | | | -30-0 | 0.100% | | | | | | | | | | | | | 1-30 | -0.100% | | | | | | | | | | | | | 31-60 | -0.130% | | | | | | | | | | | | | 61-90 | -0.169% | | | | | | | | | | | | | 91-120 | -0.220% | | | | | | | | | | | | | 121-150 | -0.286% | | | | | | | | | | | | | 151-180 | -0.372% | | | | | | | | | | | | | 181-210 | -0.500% | | | | | | | | | | | | | 求教J列取数,取数范围为奖罚系数表 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
- =IF(H4>210,-0.005,LOOKUP(H4,{-30,1,31,61,91,121,151.181},{0.001,-0.001,-0.0013,-0.00169,-0.0022,-0.00286,-0.00372,-0.005}))
复制代码
业务费计算.rar
(3.14 KB, 下载次数: 1)
|
|