请问ecxl表格函数奖金提成,1000-2000之间提成1%,2000-3000之间提成2%...答:你好!根据楼主的意思,假设A列单元格是工资,B列对应的单元格为提成,则在B2单元格里面输入公式=CHOOSE(SUM(--({1000,2000,3000,4000,5000,6000,7000,8000}<=A2))+1,0,0.01,0.02,0.03,0.04,0.05,0.06,0.07,0.08)然后把公式向下拖动,复制填充。此时看到的单元格是小数点,之后把...
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),下拉...