IF函数条件判断答:如果是根据销售金额的等级进行提成比例判断,也可以用CHOOSE函数来代替IF函数,如下图表格所示,先用IF函数多层嵌套,输入公式:=IF(C2=1,1%,IF(C2=2,1.5%,IF(C2=3,2%,IF(C2=4,3%,IF(C2=5,4.5%,IF(C2=6,6%)))如果用CHOOSE函数,输入公式:=CHOOSE(C2,1%,1.5%,2%,3%,4.5%,6%)
如何用excel if函数计算提成(高手高分)答:=IF(A2<50,0,IF(A2<100,(A2-50)*0.1,IF(A2<200,(A2-100)*0.2+5,IF(A2<300,(A2-200)*0.25+25,IF(A2<400,(A2-300)*0.3+50,IF(A2<500,(A2-400)*0.35+80,(A2-500)*0.4+115)))另外我要纠正一下,50至99应该是算50元吧?既然100-199是算100,为什么50-99就算49呢?
怎样在EXCEL里用IF函数设计提成表格?答:a列为业绩,b列为提成 =IF(A2<=40,A2*0.2,IF(A2<=100,A2*0.3,IF(A2<=300,A2*0.4,IF(A2<=500,A2*0.45,IF(A2<=1000,A2*0.5,IF(A2>1000,A2*0.55,0)))
EXCEL中怎样用IF公式计算提成?答:先假设A列数据是销售额,在B列求提成%,F2:H6为条件区域 if函数:=IF(A2>80000,8%,IF(A2>50000,5%,IF(A2>30000,4%,IF(A2>20000,3%,2%)))lookup函数:=LOOKUP(A2,$F$2:$F$6,$H$2:$H$6)vlookup函数:=VLOOKUP(A2,$F$2:$H$6,3,1)其他诸如 index+match不再一一赘述 注意事项:...
如何用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函数的计算提成操作实例答:=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%,2%)))再或 =IF(A1="","",B1*LOOKUP(A1,{0,60.01,75.01,85...