如何用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 每月阶段性提成的公式如何写答:如图,C2输入:=SUMPRODUCT(TEXT(B2-{0,20000,50000},"0;!0")*{0.35,0.05,0.05})C3输入:=SUMPRODUCT(TEXT(SUMPRODUCT((MONTH($A$2:A3)=MONTH(A3))*$B$2:B3)-{0,20000,50000},"0;!0")*{0.35,0.05,0.05})-SUMPRODUCT((MONTH($A$2:A2)=MONTH(A3))*$C$2:C2),下拉...