如何用EXCEL表格固定公式算提成,琢磨了好久还是不会~求各位大神帮忙...答:大概就是这样子 B2的公式为 =IF(A2<=5000,A2*15%,IF(A2<=10000,A2*20%,IF(A2<=20000,A2*25%,IF(A2<=30000,A2*30%,IF(A2<=40000,A2*35%,IF(A2>40000,A2*40)))自己看着调整下
销售额递增部分提成递增excel的计算公式?答:在B3单元格中输入公式:=IF(B1=300000,1%,IF(AND(B1>300000,B1<=400000),1.5%,IF(AND(B1>400000,B1<=500000),2%,IF(AND(B1>500000,B1<=600000),2.5%,IF(AND(B1>600000,B1<=700000),3%,IF(AND(B1>700000,B1<=800000),3.5%,4%)))如图:...
怎么用excel函数计算提成比例答:在E2单元格输入以下公式,然后向下填充公式,并设置E列单元格格式为百分比。=LOOKUP(D2,{0,150,400,600,800},{0,7,9,12,15}*0.1%)