excel中怎么用公式计算提成
答案:3 悬赏:10 手机版
解决时间 2021-11-08 08:14
- 提问者网友：蔚蓝的太阳
- 2021-11-08 01:46
excel中怎么用公式计算提成
最佳答案
- 五星知识达人网友：神鬼未生
- 2021-11-08 02:58
C2单元格公式改为：
=IF(C2<=0,"",LOOKUP(C2/10000,{0,6,10,15,20,30},{2.5,3,3.3,3.5,4})/100)
或者是：
=IF(C2<=0,"",TEXT(LOOKUP(C2/10000,{0,6,10,15,20,30},{2.5,3,3.3,3.5,4})/100,"0.00%"))
=IF(C2<=0,"",LOOKUP(C2/10000,{0,6,10,15,20,30},{2.5,3,3.3,3.5,4})/100)
或者是：
=IF(C2<=0,"",TEXT(LOOKUP(C2/10000,{0,6,10,15,20,30},{2.5,3,3.3,3.5,4})/100,"0.00%"))
全部回答
- 1楼网友：低血压的长颈鹿
- 2021-11-08 03:53
=C2 * VLOOKUP(C2/10000, {0,2.5; 6.0001,3; 10.0001,3.3; 15.0001,3.5; 20.0001,3.8; 30.0001,4}, 2) / 100
- 2楼网友：野慌
- 2021-11-08 03:17
将公式=C2 * VLOOKUP(C2/10000, {0,2.5; 6,3; 10,3.3; 15,3.5; 20,3.8; 30,4}, 2)/100
修改为=C2 * LOOKUP(C2/10000-0.0001, {0,6,10,15,20,30;2.5,3,3.3,3.5,3.8,4})/100
修改为=C2 * LOOKUP(C2/10000-0.0001, {0,6,10,15,20,30;2.5,3,3.3,3.5,3.8,4})/100
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯