用EXCEL编辑分段提成累加,任务2万,扣除任务5万以内7%,10万以内10%,15...答:=IF(A1-2<5,(A1-2)*0.07,IF(A1-2<10,(A1-2)*0.1,IF(A1-2<15,(A1-2)*0.15,(A1-2)*0.2)))下拉填充即可。
EXCEL分段累计公式? 比如:A等于7万,答案等于6万*0.2%+(7-6)*0.25_百...答:设原数据在b列,在c2输入:=if(a2<=60000,a2*0.2%,a2*0.2%+if(a2<=120000,(a2-60000)*0.05%,60000*0.05%+if(a2<=150000,(a2-120000)*0.05%,30000*0.05%+if(a2<=180000,(a2-150000)*0.05%,30000*0.05%+if(a2<=210000,(a2-180000)*0.05%,30000*0.05%+(a2-210000)...