阶梯工资怎么用excel计算 销售额0-5000:底薪600+销售额*5% 销售额5000...答:=IF(A1=“”,“”,LOOKUP(A1,{0,5000},{600,1000})+LOOKUP(A1,{0,5000;0.05,0.07})*A1)lookup中的值要升序排列,例如如果销售额10000及以上,底薪1500+销售额*9 =IF(A1=“”,“”,LOOKUP(A1,{0,5000,10000},{600,1000,1500})+A1*LOOKUP(A1,{0,5000,10000;0.05,0.07,0.09}...