excel提成金额达到多少提成%
答案:4 悬赏:20 手机版
解决时间 2021-11-16 03:08
- 提问者网友：嘚啵嘚啵
- 2021-11-15 09:40
excel提成金额达到多少提成%
最佳答案
- 五星知识达人网友：痴妹与他
- 2021-11-15 11:11
假设“任务”在A1中
=IF(A1<20000,A1*0.12,IF(A1<36000,A1*0.15,A1*0.18))
=IF(A1<20000,A1*0.12,IF(A1<36000,A1*0.15,A1*0.18))
全部回答
- 1楼网友：执傲
- 2021-11-15 13:28
=if(a1<20000,a1*0.12,if(or(a1>20000,a1=20000),if(a1<36000,a1*0.15),if(or(a1>36000,a1=36000),a1*0.18)))
- 2楼网友：青尢
- 2021-11-15 12:48
假如任务在D列每2行住下，在E2单元格公式如下，下拉
=IF(D2<20000,D2*0.12,IF(D2<36000,D2*0.15,D2*0.18))
=IF(D2<20000,D2*0.12,IF(D2<36000,D2*0.15,D2*0.18))
- 3楼网友：何以畏孤独
- 2021-11-15 11:27
如果任务在B2单元格，那么提成输入
=LOOKUP(B2,{0,20000,36000},{0.12,0.15,0.18})*B2
或者输入
=B2*IF(B2<20000,0.12,IF(B2<36000,0.15,0.18))
=LOOKUP(B2,{0,20000,36000},{0.12,0.15,0.18})*B2
或者输入
=B2*IF(B2<20000,0.12,IF(B2<36000,0.15,0.18))
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息
大家都在看
推荐资讯