EXCEL中怎样用IF公式计算提成?答:EXCEL中怎样用IF公式计算提成的方法如下:1、D3是数据,2、在E3输入公式:=IF(D3>=24,3.5%,IF(D3>=18,3%,IF(D3>=12,2.5%,IF(D3>=8,2%,IF(D3>=4,1%,0)))3、E列单元格的格式设置成“百分比”,小数位数设置为1。
如何用excel if函数计算提成(高手高分)?答:=if(a1>=500,(a1-499)*0.4+114.9,if(a1>=400,(a1-399)*0.35+79.9,if(a1>=300,(a1-299)*0.3+49.9,if(a1>=200,(a1-199)*0.25+24.9,if(a1>=100,(a1-99)*0.2+4.9,if(a1>=50,(a1-49)*0.1,0))),9,如何用excel if函数计算提成(高手高分)毛利(元/吨) 提...
如何运用if函数的计算提成操作实例答:假设个人达标率数据写在A1单元格,销售额数据写在B1单元格,则计算公式为 =IF(A1="","",B1*IF(A1<=0.6,0.02,IF(A1<=0.75,0.023,IF(A1<=0.85,0.026,IF(A1<=1,0.03,0.035)))或 =IF(A1="","",B1*IF(A1>1,3.5%,IF(A1>85%,3%,IF(A1>75%,2.6%,IF(A1>60%,2.3%...