如何通过Excel函数计算销售提成? 谢谢答:姓名 底薪 月售目标 月销售额 提成率 提成 月工资 甲3000 10000 50000 =LOOKUP(D2/C2,{0,0.3,1},{-0.005,0.02,0.05}) =LOOKUP(D2/C2,{0,0.3,1},{-0.005,0.02,0.05})*C2 =B2+F2 乙3000 10000 5000 =LOOKUP(D3/C3,{0,0.3,1},{-0.005,0.02,0.05}) =LOOKUP(D3/C3,{0,0.3,1},{-0.005...
如何根据销售业绩算提成要excel表格形式?3万以下不提成含;满3万的...答:假设数据在A1 在B1中输入或复制粘贴此公式 提成比例 =IF(A1="","",LOOKUP(A1,{0,30000,40000,60001},{0,1,2,5}%))提成数量 =IF(A1="","",LOOKUP(A1,{0,30000,40000,60001},{0,1,2,5}%)*A1)下拉填充