excel条件函数0-30万部分7%提成,30万-100万部分6%提成,100万以上4%...答:假设数据在A1,在B1(得出提成数值)输入或复制粘贴此公式:=IF(A1="","",LOOKUP(A1,{0,30,100},{7,6,4}%)*A1)假设数据在A1,在B1(得出提成比例)输入或复制粘贴此公式:=IF(A1="","",LOOKUP(A1,{0,30,100},{7,6,4}%))
excel中怎样用函数求提成率?答:公式:=MIN(VLOOKUP(A2,{16,0.3;18,0.8;20,1.5;22,2},2),VLOOKUP(B2,{60,0.3;75,0.8;90,1.5;105,2},2))示例:哦,补充一点,最后结果再除以100,也就是公式为=MIN(VLOOKUP(),VLOOKUP())/100
业绩提成区间计算EXCEL如何运用函数?答:公式为:=LOOKUP(A1,{0,10,15,25,35,50}*1000,{0.08,0.12,0.15,0.18,0.22,0.3})*A1 如图所示:
如何用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函数计算提成(高手高分)毛利(元/吨) 提...