完成目标的指定百分比，获取特定比例的提成，怎么算呢

Nicole_wong · 发表于 2023-5-18 14:50

yfan17 · 发表于 2023-5-18 15:06

复制代码

提成-资源=4.06

咔咔乱坠 · 发表于 2023-5-18 15:29

是算出各种类型的奖金提成吗
资源提成14，经营提成2.5，利润提成2.7

=INDEX(CHOOSE(SUM(ISNUMBER(FIND({"资源","经营","利润"},A1))*{1,2,3}),{0,0.02,0.05,0.1},{0.05,0.006,0.01,0.012},{0.025,0.03,0.1,0.2}),LOOKUP(D2/A2,{0,0.8,1,1.3},{1,2,3,4}))*D2

复制代码

		自动登录	找回密码
密码			免费注册

[求助] 完成目标的指定百分比，获取特定比例的提成，怎么算呢