excel表格怎么做提成计算??答:建议参照如下:在J4单元格中输入公式:=IF(I4<1000,"小微",IF(AND(I4>=1000,I4<5000),"三级",IF(AND(I4>=5000,I4<10000),"二级",IF(AND(I4>=10000,I4<50000),"一级","特级")))如图:
如何根据销售业绩算提成要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)下拉填充